jump to navigation

Index Internals Seminar

Note: List of currently scheduled seminars can be found on the Public Appearances page. 

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.

Introduction: Overview of Index Structures and Options

Session One: Introduction To B-Tree Indexes

Session Two: Index Statistics

Session Three: Indexes and Constraints

Session Four: Rebuilding, Coalescing and Shrinking Indexes

 Session Five: Indexes And The Cost Based Optimizer

Session Six: Miscellaneous Index Tips, Tricks and Traps

Session Seven: Linguistic Indexes

Session Eight: Additional Indexing Options

Session Nine: Partitioned Indexes

Session Ten: Bitmap Indexes

Follow

Get every new post delivered to your Inbox.

Join 1,862 other followers

%d bloggers like this: