Execution Plans in Depth
DBA, Database Developer, Consultant
For troubleshooting slow queries, looking at the execution plan is a good starting point. However, just looking at the plan does not always help. Sometimes, you need to dig deeper.
In this full-day, pre-con session, you will learn everything you need to take your understanding of execution plans to the next level. For most operators you'll find in execution plans, we will look at the inner workings and properties that affect their behaviour. We will also look at how the operators within a plan interact with each other. This will increase your understanding on why the optimizer picks a plan, and what you can do to make it pick a better plan.
In addition to explaining most operators, we will also look at how these operators interact. This will help you understand which areas in complex execution plans can cause performance issues. If you have seen some execution plans but feel you need to bring your understanding to the next level, then this pre-con session is for you!
Attendees are expected to have a good working knowledge of T-SQL