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 understanding bottlenecks in database performance. And while DBAs must understand execution plans, for proactive performance management, developers must also be able to review plans as queries and procedures get developed. In this session, you’ll learn how to gather and read execution plans, understand what query operators are and what actions they perform and understand the differences in plan types. Finally, you’ll learn how to improve your code and its performance by using the data revealed in these plans.
Oradores