Explain Plans Tips and Techniques

Have you ever tried to optimize a query but had some trouble understanding information returned from Explain Plan?  This webinar will provide the details about how Oracle processes and arrive at Explain Plans.

Join Dan Hotka, Oracle ACE Director and Embarcadero’s Scott Walz as they discuss best practice strategies and techniques for understanding Explain Plans and share tips on how to improve SQL performance.

Watch the on-demand webinar to learn:

  • 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



 

Explain Plan: Tips & Techniques with Dan Hotka


Dan Hotka is a training Specialist and an Oracle ACE Director who has over 36 years in the computer industry, and over 30 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well-published with12 Oracle books and well over 200 published articles. He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world.


Scott Walz has more than 20 years of experience in the area of database development and currently serves as the Director of Software Consultants for Embarcadero Technologies. Prior to joining Embarcadero 12 years ago, Scott served as a development lead for Louisville Gas and Electric. He holds a bachelor's degree in computer information systems from Western Kentucky University.