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

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

NYOUG Webinar: Explain the Explain Plan- Interpreting Execution Plans for SQL Statements, 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.

Meet the Speaker: Maria Colgan is a master product manager at Oracle Corporation and has been with the company since version 7.3 was released in 1996. Maria’s core responsibility is to advocate for the Oracle Database and the best practices for incorporating it into your environments. She is also responsible for getting the feedback from our customers and partners incorporated into future releases of the product. Prior to this role; she was the product manager for Oracle Database In-Memory and the Oracle Database query optimizer.

Part 1

Presentation

MColgan_Explain_the_explain_plan_Part1

Video Recording

Part 2

Presentation

Explain_the_explain_plan_Part2

Video Recording

Tagged with: , ,