Expert Oracle Indexing and Access Paths Maximum Performance for Your Database
Explains how indexes help performance, and sometimes hinder it too Demystifies the various index choices so that you can chose rightly Describes the database administration chores associated with indexes Demonstrates the use of the In Memory column store as an alternate access path to the data
Main Authors: | , , |
---|---|
Format: | eBook |
Language: | English |
Published: |
Berkeley, CA
Apress
2016, 2016
|
Edition: | 2nd ed. 2016 |
Subjects: | |
Online Access: | |
Collection: | Springer eBooks 2005- - Collection details see MPG.ReNa |
Table of Contents:
- 1. Introduction to Oracle Indexes
- 2. B-Tree Indexes
- 3. Bitmap Indexes
- 4. Index-organized Tables
- 5. Specialized Indexes
- 6. Partitioned Indexes
- 7. Tuning Index Usage
- 8. Maintaining Indexes
- 9. SQL Tuning Advisor
- 10. In Memory Column Store