Hi,
I have about 140 million columns and would like to sort multiple
columns.(This is in a way a one time process).But I would like to get
the results atleast within a day time frame.
For example
I have a table which has five columns all are numbers except one column.
id bigserial
qid numeric
kid numeric
dId numeric
uId text.
I am trying to do something like this.
select * from schema.table1 order by qid desc,kid asc,dId desc
Please explain on how do create and leverage that index for sorting.
I tried in the following manner to come up with an index but my above
query did not use this index
create index myIndex on table1(qid asc)
thanks
Sree aurovindh V
Thanks