Oracle Index Internals with Richard Foote – Prague, Czech Republic
Oracle University Training Centre
Prague, Czech Republic
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. Read more »