ASA SQL User's Guide
Working with Database Objects
Working with indexes
Selecting the best set of indexes for a database is not a problem that has a single well-defined answer. The recommendations of the Index Consultant are based on an extensive search of the outcomes of alternative indexing schemes, and careful analysis of the costs and benefits associated with indexes. Nevertheless, the nature of the problem is such that the Index Consultant recommendations cannot be guaranteed to always lead to an optimal set of indexes.
This section describes some aspects of how the Index Consultant works. The goal of the section is to provide information that enables you to better judge the recommendations it provides.
Understanding workloads
Understanding the analysis
Understanding the recommendations
Assessing the recommendations
Implementing the recommendations