[NOVICE] how to leverage index for order by - 03-22-2012 , 09:29 PM
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.
I have a table which has five columns all are numbers except one column.
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)
Sree aurovindh V
Sent via pgsql-novice mailing list (pgsql-novice (AT) postgresql (DOT) org)
To make changes to your subscription: