Thread: general question on optimizer

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