2 Day: Oracle Index Internals with Richard Foote - EMEA ONLY
Description:
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.
| Réservation / Achat | Méthodes de Formation |
Prix ** | Durée | Support | Formateur |
|---|---|---|---|---|---|
| Sessions planifiées | Cours en salle avec Formateur (ILC) | € 1474 | 2 Jours | Anglais | Anglais |
** Hors TVA
Attention !: Pour une approche plus personnalisée, merci de vous: Identifier!
Cours pré-requis:
Cours pré-requis obligatoire(s):
- Anyone who has 6+ months of experience with Oracle as a developer or DBA
Objectifs:
- Provide a clear understanding of how Oracle implements its various index structures and options
- How to ensure indexes are used and maintained appropriately in their database environments
- Help to detect, resolve and prevent issues relating to indexes
- Cover and expose myths and misconceptions regarding Oracle indexes
- Run a host of repeatable test cases in your own environments