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
How tables are processed/joined
How Indexes are processed
Explain Plan Line Items
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.