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 ...

Get Expert Oracle Indexing and Access Paths: Maximum Performance for Your Database now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.