agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Matthew Price <pricem@juno.com>
To: pgsql-sql@postgresql.org
Subject: Re: Index not being used
Date: Thu, 14 Feb 2002 22:04:24 GMT
Message-ID: <20020214.170439.16294.16467@wm8.jersey.juno.com> (raw)
>Please post your PostgreSQL version, and the actual explain output of
>both queries.
EXPLAIN SELECT cdate FROM sometable WHERE cdate = current_date;
NOTICE: QUERY PLAN:
Seq Scan on sometable (cost=0.00..332.70 rows=71 width=186)
EXPLAIN SELECT cdate FROM sometable WHERE cdate = '02/14/2002';
NOTICE: QUERY PLAN:
Index Scan using sometable_cdate on sometable (cost=0.00..66.64 rows=71 width=186)
My postgres version is 7.1.3
Again, thanks for any help
Matthew Price
________________________________________________________________
GET INTERNET ACCESS FROM JUNO!
Juno offers FREE or PREMIUM Internet access for less!
Join Juno today! For your FREE software, visit:
http://dl.www.juno.com/get/web/.
view thread (11+ messages) latest in thread
Message-ID: <20020214.170439.16294.16467@wm8.jersey.juno.com>
Permalink: ../20020214.170439.16294.16467@wm8.jersey.juno.com/
Also on: postgresql.org/message-id/20020214.170439.16294.16467@wm8.jersey.juno.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pricem@juno.com
Subject: Re: Index not being used
In-Reply-To: <20020214.170439.16294.16467@wm8.jersey.juno.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox