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.