Re: Index not being used

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Matthew Price <pricem(at)juno(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Index not being used
Date: 2002-02-14 22:38:00
Message-ID: web-694398@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Matthew,

1. Is field cdate DATE or TIMESTAMP?
2. What happens with:
EXPLAIN SELECT cdate FROM sometable WHERE cdate = '2001-02-14'::DATE or
TIMESTAMP?
3. Please time both queries and give the number of resulting rows from
both queries.

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2002-02-14 23:08:45 Re: Index not being used
Previous Message Matthew Price 2002-02-14 22:04:24 Re: Index not being used