About index ...

Поиск
Список
Период
Сортировка
От
Тема About index ...
Дата
Msg-id 200010110747.e9B7l2r38347@hub.org
обсуждение исходный текст
Ответы Re: About index ...
Список pgsql-novice
Hello,

First, excuse me for my english. I have 33 tables ( with millions rows ) and
for most tables i use btree index. My problem is when
i use explain directive. In fact btree index work only
with operator "=" . eg: select * from test where id = 45
EXPLAIN
Index scan using idx_id on test
an doesn't work with select * from test where id < 45.
EXPLAIN
Seq scan on test
Why ???

Thanks


В списке pgsql-novice по дате отправления: