Re: influenceing the optomizers choice on where clause

From: Holger Marzen <holger(at)marzen(dot)de>
To: david blood <davidjblood(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: influenceing the optomizers choice on where clause
Date: 2002-02-15 06:18:08
Message-ID: Pine.LNX.4.44.0202150715040.30871-100000@bluebell.marzen.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Holger Marzen 2002-02-15 06:22:21 Re: Pg.so problem
Previous Message Vikash Badal 2002-02-15 05:55:00 Using variables from c to be passed into PQexec