| From: | Alban Hertroys <alban(at)magproductions(dot)nl> |
|---|---|
| To: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Plan for outer joins |
| Date: | 2006-09-11 10:46:18 |
| Message-ID: | 45053E7A.7010402@magproductions.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Martijn van Oosterhout wrote:
> 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.
Oh, of course. Thanks.
--
Alban Hertroys
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marco Bizzarri | 2006-09-11 10:56:11 | Re: [GENERAL] Problem with lo_export() and lo_import() from remote machine. |
| Previous Message | Purusothaman A | 2006-09-11 10:15:26 | Re: [GENERAL] Problem with lo_export() and lo_import() from remote machine. |