Understanding Explain Plans

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.

Register Here