Home / Events / SIG Meetings & Calls / NYOUG Webinar: Explain the Explain Plan- Interpreting Execution Plans for SQL Statements – Part 1, Presented by Maria Colgan

NYOUG Webinar: Explain the Explain Plan- Interpreting Execution Plans for SQL Statements – Part 1, Presented by Maria Colgan

The execution plan for a SQL statement can often seem complicated and hard to understand. Determining if the execution plan you are looking at is the best plan you could get or attempting to improve a poorly performing execution plan can be a daunting task even for the most experienced DBA or developer. This two-part webcast series examines the different aspects of an execution plan, from cardinality estimates to parallel execution and explains what information you should be gleaming from the plan and how it affects the execution. It offers insight into what caused the Optimizer to make the decision it did as well as a set of corrective measures that can be used to improve each aspect of the plan. Part 1 covers the best techniques for generating an execution plan, understanding cardinality estimates and the different access and join methods. While part 2 covers join orders, partitioning and parallel execution.