Received: from dec50.vm.stuba.sk (dec50.vm.stuba.sk [147.175.80.10]) by hub.org (8.10.1/8.10.1) with ESMTP id e7F8YWn42864 for ; Tue, 15 Aug 2000 04:34:32 -0400 (EDT) Received: from ais.vm.stuba.sk (ais.vm.stuba.sk [147.175.80.107]) by dec50.vm.stuba.sk (8.9.3/8.9.3) with ESMTP id KAA67763 for ; Tue, 15 Aug 2000 10:38:21 +0200 (CEST) Received: from AIS/SpoolDir by ais.vm.stuba.sk (Mercury 1.43); 15 Aug 88 10:36:05 +100 Received: from SpoolDir by AIS (Mercury 1.43); 15 Aug 88 10:35:51 +100 Received: from tempest.sk (147.175.82.29) by ais.vm.stuba.sk (Mercury 1.43) with ESMTP; 15 Aug 88 10:35:47 +100 Message-ID: <399900B0.6252E318@tempest.sk> Date: Tue, 15 Aug 2000 10:34:56 +0200 From: Martin Dolog X-Mailer: Mozilla 4.74 [en] (X11; U; Linux 2.2.16 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: My Indices doesn't work Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200008/100 Hi *, I have pgsql7.0.2 on Linux2.2.16 and table with following indices: CREATE TABLE T1 (NUM INT NOT NULL, NAME VARCHAR(10) NOT NULL, POP VARCHAR(10) NOT NULL); CREATE INDEX T1_I_NUM ON T1(NUM); CREATE INDEX T1_I_NAME ON T1(NAME); CREATE INDEX T1_I_POP ON T1(POP); ... and some data, but I really don't understant how indices work, look at that: template1=# explain select * from t1 where num=2; NOTICE: QUERY PLAN: Index Scan using t1_i_num on t1 (cost=0.00..8.14 rows=10 width=28) what is ok, ***BUT*** template1=# explain select * from t1 where num>2; NOTICE: QUERY PLAN: Seq Scan on t1 (cost=0.00..22.50 rows=333 width=28) WHY SEQ SCAN ?!!? thank you -- #md