Expert Oracle Indexing and Access Paths: Maximum Performance for Your Database

Index

A

1. Advanced Index Compression

2. Asynchronous global index

3. Automatic SQL tuning

   1. architecture

   2. disabling and enabling

   3. SQL script

   4. verification

   5. viewing

4. Automatic workload repository (AWR)

B

1. Bitmap indexes

   1. advantages

   2. benefits

   3. BILLING_FACT table

   4. bitmap join indexes

      1. benefits

      2. geography dimension (GEO_ID)

      3. index creation

   5. composite bitmap index

   6. data dictionary

   7. DML mechanism

   8. drawbacks and limitations

   9. GENDER column

   10. index creation

   11. on index-organized table

   12. index partitions

   13. join indexes

       1. billing fact vs . geography dimension

   14. maintenance operations

   15. OLTP

   16. partitioned bitmap index

   17. performance implications

   18. query performance

   19. rule of thumb

   20. star schema

   21. star transformation

2. Bitmap join indexes

3. B-tree cluster index

4. B-tree indexes

   1. displaying index code

   2. dropping index

   3. foreign key constraints

      1. data dictionary views ...