Seq. scan when using comparison operators, why? [netaktiv.com #150]
От | Stephane Bortzmeyer |
---|---|
Тема | Seq. scan when using comparison operators, why? [netaktiv.com #150] |
Дата | |
Msg-id | 20020408123706.GB1307@staff.netaktiv.com обсуждение исходный текст |
Ответы |
Re: Seq. scan when using comparison operators, why? [netaktiv.com #150]
Re: Seq. scan when using comparison operators, why? [netaktiv.com #150] |
Список | pgsql-general |
I have an index on column "numero". When, I use a WHERE numero=8, PostgreSQL uses an index scan (OK) but no when using comparison operators like numero>8. essais=# explain select * from pourspip where numero>8; NOTICE: QUERY PLAN: Seq Scan on pourspip (cost=0.00..22.50 rows=333 width=28) EXPLAIN essais=# explain select * from pourspip where numero=8; NOTICE: QUERY PLAN: Index Scan using numero_idx on pourspip (cost=0.00..8.14 rows=10 width=28) EXPLAIN Why? MySQL seems able to do it "proprely": mysql> explain select * from pourspip where numero>8; +----------+-------+---------------+------------+---------+------+------+------------+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +----------+-------+---------------+------------+---------+------+------+------------+ | pourspip | range | numero_idx | numero_idx | 5 | NULL | 2 | where used | +----------+-------+---------------+------------+---------+------+------+------------+
В списке pgsql-general по дате отправления: