At a Glance; Contents; About the Authors; About the Technical Reviewer; Acknowledgments; Chapter 1: Introduction to Oracle Indexes; Index Basics; Performance Without an Index; Implementing an Index to Improve Performance; Accessing Only the Index; Oracle Ignoring an Index; Index Basics Wrap-up; Determining Which Type of Index to Use; B-tree Indexes; Index-Organized Table; Unique Indexes; Reverse Key Indexes; Key Compressed Indexes; Descending Indexes; Specialized Index Types; Bitmap Index; Bitmap Join; Function-Based Indexes; Indexed Virtual Column; Virtual Index; Invisible Index

Global and Local Partitioned IndexesDomain, B-tree Cluster, and Hash Cluster Indexes; Determining Which Columns to Index; Indexes on Primary Key and Unique Key Columns; Indexes on Foreign Key Columns; Other Suitable Columns; Indexing Guidelines; Summary; Chapter 2: B-tree Indexes; Understanding How Oracle Uses B-tree Indexes; Prepping for B-tree Indexes; Estimating the Size of an Index Before Creation; Creating Separate Tablespaces for Indexes; Inheriting Storage Parameters from the Tablespace; Naming Standards; Implementing B-tree Indexes; Creating a B-tree Index; Reporting on Indexes

Displaying Index CodeDropping a B-tree Index; Managing B-tree Indexes with Constraints; Creating B-tree Index on Primary Key Columns; Use ALTER TABLE to Create a Primary Key Constraint and Index; Use CREATE TABLE to Create a Primary Key Constraint and Index; Create a B-tree Index and Primary Key Constraint Separately; Viewing Primary Key Constraint and Index Details; Dropping the Primary Key Constraint and Index; Creating a B-tree Index on Unique Key Columns; Use the ALTER TABLE to Create a Unique Constraint and Index; Use CREATE TABLE to Create a Unique Constraint and Index

Create a B-tree Index and Unique Key Constraint SeparatelyCreating Only a Unique Index; Dropping a Unique Key Constraint and Index; Indexing Foreign Key Columns; Unnecessary Locking; Implementing an Index on a Foreign Key Column; Determining if Foreign Key Columns Are Indexed; Multiple Indexes on the Same Column Combinations; Extended Data Types; Indexing Extended Columns; Virtual Column Solution; Function-Based Index Solution; Summary; Chapter 3: Bitmap Indexes; Understanding Bitmap Indexes; Creating a Bitmap Index; Creating a Partitioned Bitmap Index

Creating a Bitmap Index on an Index-Organized Table Performance Implications of Querying with Bitmap Indexes; Performance Implications of Loading Data with Bitmap Indexes; Understanding Bitmap Join Indexes; Creating a Bitmap Join Index; Duplicating Indexes for Performance; Reporting on Bitmap Indexes; Summary; Chapter 4: Index-Organized Tables; Understanding the Structure; Understanding the Advantages; Creating an Index-Organized Table; Adding an Overflow Segment ; Compressing an Index-Organized Table; Building Secondary Indexes; Rebuilding an Index-Organized Table