What You See Is What You Get Element

Understanding Explain Plans & Index Utilization
Online Training with Dan Hotka

8-9 May 2012
10:00-14:00 CET

Register Now

Save the date for May 8-9
Visit our Facebook page
Follow us on Twitter
Join our LinkedIN Group

Meet the Expert

Andrejus Baranovskis

Dan Hotka is a training specialist and an internationally recognised Oracle expert. He has over 31 years experience in the computer industry - over 26 years of them working with Oracle products. Dan's latest book is the TOAD Handbook (Pearson). He frequently publishes in Oracle trade journals and regularly speaks at Oracle conferences and user groups around the world. Visit his website at www.DanHotka.com.


"This was a great class, if for no other reason than it's super to learn from someone who knows their stuff as well as he does!"

"Excellent class! I liked all the examples and conclusions of each of them. It really was tailored to my needs"

"Learned a lot of interesting things, the length was good and the pace was excellent, this was good training"

Mention this code at the time of booking: E1019

Live Virtual Oracle Expert Seminar

Oracle University seminars are all exclusive events delivered by top
experts with years of experience in working with Oracle products.

The Explain Plans & Index Utilization seminar takes a close look at an Explain Plan, which shows how a relational database accesses data, and at how to retrieve the right data from your Oracle Database. All concepts will be illustrated with live examples and real-life stories from Dan Hotka’s personal experience.

Why should you attend this seminar?

  • To understand how your applications can take advantage of your computing environment
  • To learn coding techniques so that SQL runs at maximum performance
  • To understand how indexes really work
  • To know when to apply which index
  Register Now


Day 1: 10:00 – 14:00 CET: Understanding Explain Plans

  • How does Oracle process your SQL
  • Good and poor Explain Plans
  • Influencing  the Oracle Explain Plan
  • Code to insure the SQL maximizes performance
  • Using Explain Plan options
  • Parallel Explain Plans
  • How to spot SQL problems by reviewing the Explain Plan

Day 2: 10:00  – 14:00 CET: Working with Indexes

  • Various Index Options, both B-Tree and Bitmap Indexes
  • Utilizing HINTS to improve Index selectivity
  • CBO Statistic Options
  • Monitoring Indexes
  • Understanding how Indexes work
  • Identifying a poor-quality index

Both days include a variety of scripts to aid you viewing Explain Plan options and monitoring Indexes.

Mention this code at the time of booking: E1019
Hardware and Software, Engineered to Work Together Oracle University