File Library

Understanding Explain Plans
Topic: Webinars
Owner: Dan Hotka
Date: 2012-09-12
Subtopic: Administration

This presentation is a must-see for anyone doing SQL tuning. Dan has a thorough understanding of how the Cost-Based Optimizer works and shares that knowledge in this presentation. 

Dan covers: 

-Useful Explain Plan tools and scripts
-Understanding Oracle Explain Plan
-How the CBO makes its decisions 
-Query Transformations  
-How tables are processed/joined 
-How indexes are processed  
-Explain Plan line items    

This is a live-demo presentation. Dan shows how to work with Explain Plans then goes into considerable detail about exactly how Oracle arrives at an Explain Plan. Dan is an experienced trainer with considerable knowledge on this topic. The attendee will gain valuable insights as to how Oracle processes SQL and many tips on how to improve SQL performance.

Download File   2011-06-07_15.02_Understanding_Explain_Plans,_Dan_Hotka,

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database

Click here to see the Full Techincal Resource Database