Re: Creating Index - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: Creating Index
Date
Msg-id 20031001110830.O40704@megazone.bigpanda.com
Whole thread Raw
In response to Re: Creating Index  ("CN" <cnliou9@fastmail.fm>)
Responses Re: Creating Index
List pgsql-sql
On Wed, 1 Oct 2003, CN wrote:

> Peter, Thanks a lot!
>
> > Unqualified count() cannot use an index because it has to visit all the
> > rows in the table.
>
> It is only for my test. In my real practice, queries like
> "SELECT * FROM view1 WHERE year = 2003 AND month BETWEEN 10 AND 12"
> will be performed.

You do realize that extract returns a double precision value not an
integer, and it's probably not going to be willing to push clauses down
through the union where the types are different .



pgsql-sql by date:

Previous
From: "CN"
Date:
Subject: Re: Creating Index
Next
From: "Vishal Charan (IT Fiji)"
Date:
Subject: