Re: Plan for outer joins

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