Tailoring for Performance › Minimizing the Number of Active Indexes › Sharing Active Indexes

Sharing Active Indexes

The following example shows a shared active index.

The compilation sequence can affect the number of active indexes required.

In the previous example, if the compilation sequence is LGL1, LGL2, LGL3, one active index is created. Since the key sequence for LGL2 and LGL3 are subsets of LGL1, they can share the same active index.

If the compilation sequence is LGL3, LGL2, LGL1, three active indexes are created because the key sequence for LGL2 and LGL1 are not subsets of LGL3.