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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
