On Mon, May 23, 2011 at 05:31:04PM +0530, Nick Raj wrote:
> Hi,
> I have build an index. When, i execute the query, it gives the result by
> sequential scan, not by using my index.
> For that, i have set enable_seqscan=off in postgresql.conf. But it still
> going through sequential scan.
It sounds like your index can't actually be used to satisfy your
query. Without seeing the table definition, index definition, and
query, however, it's pretty hard to give you a real answer.
A
--
Andrew Sullivan
ajs@crankycanuck.ca