Tailoring for Performance › Minimizing the Number of Active Indexes › The Active Index

The Active Index

The following example shows separate active indexes:

It is important to minimize the number of active indexes because active indexes cause extra system overhead. Active indexes sharing multiple access paths in the design model do not always equate to multiple indexes. For example, the UPD and RTV access paths have the same active indexes.