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

--
Sent via pgsql-novice mailing list (pgsql-novice (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice