| From: | "Kim Yunhan" <spbear(at)hanmail(dot)net> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Index Problem |
| Date: | 2001-02-09 14:54:08 |
| Message-ID: | 20010209145408.HM.40000000001Vhp4@www5.hanmail.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
I want to query this...
--> SELECT * FROM bbs ORDER BY ref desc, step ASC LIMIT 12;
this query doesn't refer the index that made by this query.
--> CREATE INDEX idx_bbs ON bbs (ref, step);
but, i change the query that "ref desc" to "ref asc".
then query refer the index, and i can see a result very fast. :-(
so, i want to view an result that one column ordered by ascending, and oterh column ordered by descending using index.
what do i do?
how make an index?
==================================================
==================================================
우리 인터넷, Daum
평생 쓰는 무료 E-mail 주소 한메일넷
지구촌 한글 검색서비스 Daum FIREBALL
http://www.daum.net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kim Yunhan | 2001-02-09 15:06:19 | Index Problem |
| Previous Message | Kim Yunhan | 2001-02-09 13:05:24 | Index problem... |