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
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.
>> 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.
Sign Up to Receive 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.