Summary
B-tree indexes are the default index type used in Oracle databases. For most applications, B-tree indexes are sufficient. With high cardinality columns, a B-tree index will usually provide considerable performance benefits.
When creating an index, we recommend that you place the index in a tablespace separate from its corresponding table. This allows you more options for storage management and backup and recovery. This isn't a hard-and-fast rule, but rather a guideline to help with maintenance and manageability.
B-tree indexes are closely associated with primary key and unique key constraints. Oracle will automatically create a B-tree index for you when the primary key or unique key constraint is created. When an index is automatically ...
Get Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
