Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1CExex08105 for ; Mon, 12 Feb 2001 09:59:40 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from smail-12.hanmail.net ([211.233.30.161]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f194GBx68280 for ; Thu, 8 Feb 2001 23:16:12 -0500 (EST) (envelope-from spbear@hanmail.net) Received: from www5.hanmail.net (www5.hanmail.net [211.32.117.25]) by smail-12.hanmail.net (8.10.0/8.9.1) with ESMTP id f1946fN18685; Fri, 9 Feb 2001 13:06:42 +0900 Received: (from hanadmin@localhost) by www5.hanmail.net (8.10.0/8.9.1) id f1945OP17646; Fri, 9 Feb 2001 13:05:24 +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 13:05:24 KST Message-Id: <20010209130524.HM.40000000001VffJ@www5.hanmail.net> Errors-To: MIME-Version: 1.0 Content-Type: text/plain; charset=euc-kr Content-Transfer-Encoding: 8bit X-Archive-Number: 200102/204 X-Sequence-Number: 1393 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