Subscribe to this blog
Archives: March 2010
Left outer join vs NOT EXISTS
And to wrap up the miniseries on IN, EXISTS and JOIN, a look at NOT EXISTS and LEFT OUTER JOIN for finding non-matching rows.
For previous parts, see
I’m looking at NOT EXISTS and LEFT OUTER JOIN, as… Read more
14 comments, 1,591 reads
Posted in SQL In The Wild on 23 March 2010
The Root of all Evil
Or “Shot gun query tuning”
There have been a fair few forums questions in recent months asking for help in removing index scans, loop joins, sorts or other, presumed, slow query operators. There have been just as many asking how to replace a subquery with a join or… Read more
1 comments, 76 reads
Posted in SQL In The Wild on 11 March 2010