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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
