index on int2.

From: "Vladimir Dobrokhotov" <dvs(at)rybvod(dot)kamchatka(dot)su>
To: <pgsql-sql(at)postgreSQL(dot)org>
Subject: index on int2.
Date: 1999-01-29 05:40:37
Message-ID: 01be4b49$e63ce980$9065a8c0@dvs.rybvod.kamchatka.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Remigiusz Sokolowski 1999-01-29 08:43:33 Re: [SQL] Character type name?? How to lower case it?
Previous Message Antonio Badia 1999-01-28 23:18:49 SQL parser