Re: Queries not using Index - Mailing list pgsql-sql

On Mon, 22 Jul 2002, Daryl Herzmann wrote:

> snet=# explain SELECT * from t2002_06 WHERE station = 'SGLI4';
> NOTICE:  QUERY PLAN:
>
> Seq Scan on t2002_06  (cost=0.00..35379.69 rows=35564 width=47)
>
> EXPLAIN

What does explain show if you do set enable_seqscan=off;
?
It's possible that it's estimating a greater cost for the index scan.