Received: from localhost.hanmail.net ([211.62.252.62]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1960Sx75754 for ; Fri, 9 Feb 2001 01:00:28 -0500 (EST) (envelope-from spbear@hanmail.net) Received: from www5.hanmail.net (www5.hanmail.net [211.32.117.25]) by localhost.hanmail.net (8.10.0/8.9.1) with ESMTP id f195t0N14411; Fri, 9 Feb 2001 14:55:00 +0900 Received: (from hanadmin@localhost) by www5.hanmail.net (8.10.0/8.9.1) id f195s8Q29145; Fri, 9 Feb 2001 14:54:09 +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 14:54:08 KST Message-Id: <20010209145408.HM.40000000001Vhp4@www5.hanmail.net> Errors-To: MIME-Version: 1.0 Content-Type: text/plain; charset=euc-kr Content-Transfer-Encoding: 8bit X-Archive-Number: 200102/170 X-Sequence-Number: 1356 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