jump to navigation

Index Internals Seminar

As I now work directly for Oracle Corporation, I can no longer run these seminars. However, if you ask your friendly Oracle University folks and there’s enough local interest, who knows what could be arranged 🙂

Please contact me at richard.foote@bigpond.com for further information or availability.

I currently present a very in-depth 2 day Oracle Indexing Internals and Best Practices Seminar. There is also a condensed 1 day version of the Oracle Index Internals and Best Practices Seminar upon request.

Indexes are fundamental to every Oracle database and are crucial for optimal performance. However, there’s an incredible amount of misconception, misunderstanding and pure myth regarding how Oracle indexes function and should be maintained. This seminar examines most Oracle index structures and discusses in considerable detail how they function and how they should be used and maintained. Much of the material is not easily available in Oracle documentation or in standard Oracle University courses.

This seminar would be of much benefit to not only DBAs, but also to Developers, Solution Architects and anyone else interested in designing and developing high performance Oracle-based applications.

Session One: Overview of Index Structures and Options

Session Two: Introduction To B-Tree Indexes

Session Three: Index Statistics

Session Four: Indexes and Constraints

Session Five: Rebuilding, Coalescing and Shrinking Indexes

Session Six: Indexes And The Cost Based Optimizer (CBO)

Session Seven: Miscellaneous Index Tips, Tricks and Traps

Session Eight: Additional Indexing Options

Session Nine: Partitioned Indexes

Session Ten: Bitmap Indexes


Optional Section: Indexing with Exadata

%d bloggers like this: