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