Tuning queries that project scalar subqueries
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.
Course Features
- Lectures 1
- Quizzes 0
- Duration 7 minutes
- Skill level All levels
- Language English
- Students 3
- Certificate No
- Assessments Yes
Leave A Review
Please provide as much detail as you can to justify your rating and to help others.
Login with Facebook
Login with Google