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
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...
> appa
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.
Shouldn't the planner notice that the right part of SELE
