As DBAs, we know that few tools are as critical to SQL optimization as the SQL execution plan. The ability to read and understand an execution plan is critical to evaluating and optimizing SQL performance. Unfortunately, complex plans are daunting and can be difficult to understand.
Fortunately, Karen Morton will walk you through a relatively short and easy to follow set of guidelines for how to read an execution plan and how to make sense of the operations and statistics (both estimated and actual) the plan output provides. Learn how to leverage one of the most important tools at your disposal.
Topics covered in this webinar include:
How to read an execution plan, and how various plan operations work
How to use the plan to pinpoint performance problems
Tools to accelerate you analysis of execution plan data
*Please note that Karen uses Oracle SQL database in her examples.
About the presenter:
Karen Morton is a consultant and educator specializing in Oracle performance optimization in both shoulder-to-shoulder consulting engagements and classroom settings. She is an Infrastructure Principal Director for Accenture Enkitec Group, a global systems integrator specializing on the Oracle platform.
For almost 30 years, Karen has worked in information technology. Starting as a mainframe programmer and developer, she has been a DBA, a data architect and now is an author, researcher, educator and consultant. Having used Oracle since the early 90's, she began teaching others how to use Oracle almost 20 years ago.