Tuning queries that project scalar subqueries
Duration: 7 minutes
Free
The ability to project scalar subqueries is very useful, and many developers rely on it. But! The cost of correlating the subquery may be astronomical. This tutorial shows how to read the execution plan, and how to rewrite the query (safely) to a much more efficient structure.