Index Problem

From: "Kim Yunhan" <spbear(at)hanmail(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Index Problem
Date: 2001-02-09 15:06:19
Message-ID: 20010209150619.HM.40000000001Vi4f@www5.hanmail.net
Views: Raw Message | Whole Thread | 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message rob 2001-02-09 17:14:51 Re: plpgsql grief
Previous Message Kim Yunhan 2001-02-09 14:54:08 Index Problem