Author Webcasts from Pearson

Understanding Oracle Explain Plans

Live Event • Tuesday, November 10 • 11:00 a.m. EST / 8:00 a.m. PST

Presented by Dan Hotka

Experienced trainer Dan Hotka shows you how to work with Explain Plans, then goes into considerable detail about exactly how Oracle arrives at an Explain Plan. Dan has a thorough understanding of how the Cost-Based Optimizer works, and shares that knowledge in this presentation. You will gain valuable insights as to how Oracle processes SQL, and many tips on how to improve SQL performance. This presentation is a must-see for anyone doing SQL tuning. Download the slide deck here (949 KB .pdf).

What you will learn:

  • Useful Explain Plan tools and scripts
  • Understanding Oracle Explain Plans
  • How the CBO makes its decisions
  • Query Transformations
  • How tables are processed/joined
  • How Indexes are processed
  • Explain Plan Line Items
Dan Hotka
Oracle ACE Director

Dan Hotka is a Training Specialist and an Oracle ACE Director who has more than 37 years in the computer industry, and more than 31 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, and has authored 14 Oracle books and well more than 200 published articles. He frequently writes for Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world.

 
 


 
Check out books, eBooks, and videos by Dan Hotka

Now through January 8, save 60% on video training by Dan Hotka
when you apply discount code HOTKAWCVID at checkout.

Toad for Oracle LiveLessons
Toad for Oracle LiveLessons
Video *$79.99 $199.99
Oracle SQL LiveLessons
Oracle SQL LiveLessons
Video *$99.99 $249.99
 

>> See more from Dan Hotka

 

Also through January 8, save 40% on select books and eBooks by Dan Hotka when you apply discount code HOTKAWC at checkout.

Toad for Oracle Unleashed
Toad for Oracle Unleashed
Book **$29.99 $49.99
eBook **$23.99 $39.99
 

Sign Up to Receive Special Offers

Sign me up!

 

I would like to hear from InformIT and its family of brands about products and special offers.

 


* Sale prices displayed reflect 60% discount achieved with purchase of eligible title on informit.com and application of discount code HOTKAWCVID during checkout. Discount code HOTKAWCVID confers 60% discount off the list price of ISBNs 9780134289328, 9780134289304, 9780134117027, 9780134214443, 9780134275741, 9780134289120, 9780134289144, 9780134291406, or 9780134384108 only. Discount may not be applied to book/eBook + video bundles, Safari Books Online, non-discountable titles, or any title featured as Video Deal of the Week. Discount code may not be combined with any other offer and is not redeemable for cash. Discount offer expires 11:59 p.m. EST January 8, 2016. Offer subject to change.

** Sale prices displayed reflect 40% discount achieved with purchase of eligible title on informit.com and application of discount code HOTKAWC during checkout. Discount code HOTKAWC confers 40% discount off the list price of ISBNs 9780132652186, 9780134131856, 9780134131924, or 9780321649102 only. Discount may not be applied to book + eBook "Best Value" or "Additional Savings" bundles, Rough Cuts, Safari Books Online, non-discountable titles, or any title featured as eBook Deal of the Week. Discount code may not be combined with any other offer and is not redeemable for cash. Discount offer expires 11:59 p.m. EST January 8, 2016. Offer subject to change.