Understanding Explain Plans & Index Utilization

What You See Is What You Get Element


Understanding Explain Plans & Index Utilization Online Training with Dan Hotka

	10-11 January 2012 10:00-14:00 CET

	Save the date for Jan 10-11
	Visit our Facebook page
	Follow us on Twitter
	Join our LinkedIN Group

Meet the Expert

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.

Quotes:

"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"

Oracle University seminars are all exclusive events delivered by top
Oracle 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

Topics

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
Using Explain Plan options
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.

SEV100021355