| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Alban Hertroys <alban(at)magproductions(dot)nl> |
| Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Plan for outer joins |
| Date: | 2006-09-11 10:05:45 |
| Message-ID: | 20060911100545.GC16564@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Sep 11, 2006 at 11:58:56AM +0200, Alban Hertroys wrote:
> Hi,
>
> I was tuning a join on a few tables for a SELECT COUNT(*) query, when I
> realized that the content of the second table didn't actually matter to
> the count. So, I figured a LEFT OUTER JOIN would be faster, but...
> apparently it's not.
Well, it would matter if the outer side of the join could return more
than one row. You may know that won't happen, but the database may not.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marco Bizzarri | 2006-09-11 10:07:06 | Re: [GENERAL] Problem with lo_export() and lo_import() from remote machine. |
| Previous Message | Martijn van Oosterhout | 2006-09-11 10:03:36 | Re: [GENERAL] Problem with lo_export() and lo_import() from remote machine. |