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.
Course Features
- Lectures 1
- Quizzes 0
- Duration 7 minutes
- Skill level All levels
- Language English
- Students 3
- Assessments Yes
-
Untitled
