general question on optimizer

From: chester c young <chestercyoung(at)yahoo(dot)com>
To: sql pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: general question on optimizer
Date: 2007-11-11 00:23:42
Message-ID: 994792.8624.qm@web54302.mail.re2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I have found that in many complex queries left join is exponentially
faster than a (not) exists clause.

I don't understand why, generally speaking, this is so frequently so
effective.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Browse pgsql-sql by date

  From Date Subject
Next Message Bart Degryse 2007-11-12 08:23:18 Re: Select in From clause
Previous Message Tom Lane 2007-11-10 23:14:50 Re: functions are returns columns