Index Problem

Поиск
Список
Период
Сортировка
От Kim Yunhan
Тема Index Problem
Дата
Msg-id 20010209150619.HM.40000000001Vi4f@www5.hanmail.net
обсуждение исходный текст
Ответы PL/PGSQL Cook Book  (mark proctor <m.proctor@bigfoot.com>)
Список 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


В списке pgsql-sql по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Index Problem
Следующее
От: Najm Hashmi
Дата:
Сообщение: pgsql and cursor