From: Kim Yunhan <spbear@hanmail.net>
To: pgsql-sql@postgresql.org
Subject: Index Problem
Date: Fri, 09 Feb 2001 15:06:19 KST
Message-ID: <20010209150619.HM.40000000001Vi4f@www5.hanmail.net> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: spbear@hanmail.net
Subject: Re: Index Problem
In-Reply-To: <20010209150619.HM.40000000001Vi4f@www5.hanmail.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox