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'
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 |