Received: from smail-15.hanmail.net ([211.233.30.162]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f19AeHx18084 for ; Fri, 9 Feb 2001 05:40:18 -0500 (EST) (envelope-from spbear@hanmail.net) Received: from www5.hanmail.net (www5.hanmail.net [211.32.117.25]) by smail-15.hanmail.net (8.10.0/8.9.1) with ESMTP id f1966xH21949; Fri, 9 Feb 2001 15:06:59 +0900 Received: (from hanadmin@localhost) by www5.hanmail.net (8.10.0/8.9.1) id f1966JF10797; Fri, 9 Feb 2001 15:06:19 +0900 (KST) X-Originating-IP: [203.253.24.54] From: "Kim Yunhan" Reply-To: "Kim Yunhan" Organization: Soongsil Univ. To: pgsql-sql@postgresql.org Subject: Index Problem X-Mailer: Daum Web Mailer 1.0 Date: Fri, 09 Feb 2001 15:06:19 KST Message-Id: <20010209150619.HM.40000000001Vi4f@www5.hanmail.net> Errors-To: MIME-Version: 1.0 Content-Type: text/plain; charset=euc-kr Content-Transfer-Encoding: 8bit X-Archive-Number: 200102/172 X-Sequence-Number: 1358 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