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.

Attachment: signature.asc
Description: This is a digitally signed message part

Reply via email to