Re: Index Scans become Seq Scans after VACUUM ANALYSE

On Thu, 18 Apr 2002 Maarten.Boekhold@reuters.com wrote:

> 
> On 04/17/2002 01:44:46 PM Michael Loftis wrote:
> > In many of the cases where it is a primary key it is also there to
> > ensure fast lookups when referenced as a foreign key.  Or for joins.
> 
> Don't know if the optimizer takes this into consideration, but a query that uses a primary and/or unique key in the
where-clause,should always choose to use
 
> the related indices (assuming the table size is above a certain threshold). Since a primary key/unique index always
restrictsthe resultset to a single row.....
 

I don't think so.

eg. table with primary key "pk", taking values from 1 to 1000000 (so
1000000 records)

select * from table where pk > 5

should probably not use the index ...

Cheers
Tycho

-- 
Tycho Fruru            tycho.fruru@conostix.com
"Prediction is extremely difficult. Especially about the future." - Niels Bohr