| From: | sreeaurovindh viswanathan <sreeaurovindh(at)gmail(dot)com> |
|---|---|
| To: | PGSQL-Novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | how to leverage index for order by |
| Date: | 2012-03-23 03:29:41 |
| Message-ID: | CAC4BLaLMSisbOZ+YKV7AX=dtexO=3ia_1XmZfU=gCwXHt=Oc3Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cheng | 2012-03-23 16:26:14 | Define a function that accepts query result as a parameter |
| Previous Message | sreeaurovindh viswanathan | 2012-03-22 15:43:35 | Re: Regarding Copy in postgresql |