| 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: | Whole Thread | Raw Message | 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)
>
| 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) |