Re: influenceing the optomizers choice on where clause - Mailing list pgsql-general

On Thu, 14 Feb 2002, david blood wrote:

> I thought I read somewhere but can't find it that the execution of the where
> clause statements in up to the optimizer.  Is there a way to affect that?

Yes. You can - for example - encourage it to use indexes (indices?) even
if it would prefer a table scan.

See the online docs:
Chapter 3. Server Runtime Environment
-> 3.4.1. Planner and Optimizer Tuning

--
PGP/GPG Key-ID:
http://blackhole.pca.dfn.de:11371/pks/lookup?op=get&search=0xB5A1AFE1