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