On Wed, 2003-10-01 at 13:30, Dimitri Nagiev wrote: > Hi all, > > I haven't found any official documentation about the postgres sql optimizer > on the web, so please forgive me if there is such a document and point me to > the right direction. > > I've got the following problem: I cannot make the postgres SQL Optimizer use > an index on a date field to filter out a date range, e.g. > > select * from mytable where mydate >= '2003-10-01'; > > Seq Scan on mytable (cost=0.00..2138.11 rows=12203 width=543) > Filter: (mydate >= '2003-09-01'::date)
EXPLAIN ANALYZE output please.
signature.asc
Description: This is a digitally signed message part