Received: from rybvod.kamchatka.su (rybvod.kamchatka.su [212.19.19.253]) by hub.org (8.9.2/8.9.1) with ESMTP id AAA55447 for ; Fri, 29 Jan 1999 00:36:23 -0500 (EST) (envelope-from dvs@rybvod.kamchatka.su) Received: from dvs.rybvod.kamchatka.su (orr-0.intra.rybvod.kam [192.168.101.144]) by rybvod.kamchatka.su (8.8.8/8.8.5) with SMTP id RAA01995 for ; Fri, 29 Jan 1999 17:48:17 +1200 (PS) From: "Vladimir Dobrokhotov" To: Subject: index on int2. Date: Fri, 29 Jan 1999 17:40:37 +1200 Message-ID: <01be4b49$e63ce980$9065a8c0@dvs.rybvod.kamchatka.su> MIME-Version: 1.0 Content-Type: text/plain; charset="koi8-r" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.71.1712.3 X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3 Hello, I create index on int2 field, and it never used: create index xxx on ttt using btree(int2_field); vacuum ttt; (2600 tuples) explain select * from ttt where int2_field>1; ... Seq Scan on ttt ... What I need to do to use index search? Thanks. Vladimir Dobrokhotov