Thread: index on int2.

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