2 Day Seminar: Oracle Index Internals with Richard Foote - Prague, Czech Republic October 24, 2010

Indexes are a crucial component in any Oracle database. This two-day seminar is a detailed study of how various index structures are implemented by Oracle, including B-Tree, Reverse Key, Function-Based, Bitmap, Bitmap Join, Partitioned, Linguistic and Text Indexes. It discusses index internals, how indexes should be maintained and importantly examines how the Cost Based Optimizer determines their use or otherwise.

The seminar also dispels many common myths and misconceptions associated with Oracle indexes by proving index behavior with clearly defined case studies and repeatable test examples. Featuring many useful tips and tricks and current 11g new features, attendees will gain a solid knowledge of the various Oracle index structures and a clear understanding of appropriate index maintenance and index usage strategies.