Prepping for B-tree Indexes

Before creating a B-tree index, it's prudent to make a few architectural decisions that will impact maintainability and availability. The following are manageability features that you should consider before building indexes:

  • Estimate the size of the index before creating it.
  • Consider designating a tablespace just for indexes (separate from tables). This allows you to more easily manage indexes separately from tables for tasks such as backup and recovery.
  • Allow objects to inherit storage parameters from their tablespace.
  • Define naming standards to be used when creating indexes.

These decision points are detailed in the following subsections.

Estimating the Size of an Index Before Creation

Before creating an index ...

Get Expert Indexing in Oracle Database 11g: 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.