If your index is not performing as expected, you may want to consider the following actions:

• Reorganize composite indexes.
• Increase the page size.

These measures improve index selectivity and index fan-out.

 See also