Re: influenceing the optomizers choice on where clause

From: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>
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 03:14:11
Message-ID: 20020214231230.F86207-100000@mail1.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


use explicit JOINs can get around this ... check out this thread in
pgsql-sql:

http://archives.postgresql.org/pgsql-sql/2001-06/msg00318.php

I found it the other day as I had to remind myself how to do it :)

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?
>
>
> __________________________________________________
> Do You Yahoo!?
> Got something to say? Say it better with Yahoo! Video Mail
> http://mail.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andre' Blanchard 2002-02-15 03:15:06 How to properly build postgresql version 7.2 on Unix Platforms?
Previous Message Thomas Lockhart 2002-02-15 03:01:06 Re: Replication (sigh)