using indexes
| От | Sferacarta Software |
|---|---|
| Тема | using indexes |
| Дата | |
| Msg-id | 13548.981019@bo.nettuno.it обсуждение исходный текст |
| Список | 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'
В списке pgsql-hackers по дате отправления: