using indexes

From: Sferacarta Software <sferac(at)bo(dot)nettuno(dot)it>
To: pgsql-hackers(at)postgresql(dot)org
Subject: using indexes
Date: 1998-10-19 11:09:58
Message-ID: 13548.981019@bo.nettuno.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello all,

I have a table SP with a primary key SNO,
I'm trying if v6.4beta2 uses indexes
but seems it uses indexes only with '=' operator:

prova=> explain select * from sp where sno = 'S1';
NOTICE: QUERY PLAN:
Index Scan using sp_pkey on sp (cost=0.00 size=0 width=28)
EXPLAIN

prova=> explain select * from sp where sno = 'S1' or sno = 'S2';
NOTICE: QUERY PLAN:
Seq Scan on sp (cost=0.00 size=0 width=28)
EXPLAIN

prova=> explain select * from sp where sno <> 'S1';
NOTICE: QUERY PLAN:
Seq Scan on sp (cost=0.00 size=0 width=28)
EXPLAIN

prova=> explain select * from sp where sno > 'S1';
NOTICE: QUERY PLAN:
Seq Scan on sp (cost=0.00 size=0 width=28)
EXPLAIN
prova=> explain select * from sp where sno < 'S1';
NOTICE: QUERY PLAN:
Seq Scan on sp (cost=0.00 size=0 width=28)
EXPLAIN

Jose'

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexey Ugnichev 1998-10-19 11:13:32 Very sorry - testing...
Previous Message Sferacarta Software 1998-10-19 10:57:54 HAVING bug