When tuning a SQL statement that includes a join, the most important thing is the join order. If there is such a thing as a “silver bullet” for SQL tuning, it is that, the join order. This tutorial will show how to use something called the Filtered Rows Percentage method to calculate what the join order should be, and validate the plan chosen by the optimizer uses that join order.
Course Features
- Lecture 1
- Quiz 0
- Duration 13 minutes
- Skill level All levels
- Language English
- Students 0
- Assessments Yes
-
Tutorial
