Fun with Outer Joins
Ever heard something like this?
“No wonder this application has so many performance problems – just look at how many outer joins are scattered all through the SQL!”
•The “problem of outer joins” is largely a myth!
•I have never seen a query where an
outer join was the true root cause of a query’s poor performance!
•Correct outer joins perform as well as inner
joins!
•However, outer joins are subtle and easy to
mis-code.