Execution Plans for Beginners: What I wish I knew, when.

Monica Rathbun

Do you struggle to understand why a query is running slowly? Or why it runs in less than a second most of the time, and takes 10 minutes other times? Being able to review and understand query execution plans is essential to understand bottlenecks in database performance. While DBAs need to be able to understand execution plans, proactive performance management developers need to be able to review plans as queries and procedures get developed.

In this session you will learn you how to gather and read execution plans, understand what query operators are and what actions they perform, as well as understand the differences in plan types. Finally, you will learn how to improve your code and it’s performance by using the data revealed in these plans. Join me for the start of the Query Tuning Pathway.