O'Reilly logo

Expert Oracle Indexing and Access Paths: Maximum Performance for Your Database by Bill Padfield, Sam R Alapati, Darl Kuhn

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required