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 application optimization in both shoulder-to-shoulder consulting engagements and classroom settings. She is a Senior Technical Consultant for Enkitec, a global systems integrator specializing on the Oracle platform.
For over 25 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 a researcher, educator and consultant. Having used Oracle since the early 90's, she began teaching others how to use Oracle over 15 years ago.
Karen is a frequent speaker at conferences and user groups, an Oracle ACE, and a member of the OakTable network.