Level: Introductory to Intermediate
This session will provide you with a simple set of tasks to get you started reading execution plans.
The best way to understand why your query is running slow is to look at the execution plan. But, knowing how to get started in execution plans, what to look for, what's important can all be terribly confusing. This session will provide you with a simple set of tasks to get you started reading execution plans. You'll learn where to start, what to look for first, and you'll be better prepared to tune your queries. We'll also look at some methods you can use to write queries against the plans themselves in order to more easily and quickly identify potential issues within your plans. The information presented will be immediately applicable on the queries you have running back in the office.
You will learn:
- Understand how to get useful information out of execution plans
- Learn where to look at execution plans to understand what things are, what they mean, and what they're doing to the data
- To make appropriate changes to improve performance on your queries