Обсуждение: index on int2.

Поиск
Список
Период
Сортировка

index on int2.

От
"Vladimir Dobrokhotov"
Дата:
Hello,

I create index on int2 field, and it never used:

create index xxx on ttt using btree(int2_field);
vacuum ttt; (2600 tuples)
explain select * from ttt where int2_field>1;
... Seq Scan on ttt ...

What I need to do to use index search?

Thanks.
Vladimir Dobrokhotov