Contents Index Stopping the Index Consultant Understanding workloads

ASA SQL User's Guide
  Working with Database Objects
    Working with indexes

Understanding the Index Consultant


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

Contents Index Stopping the Index Consultant Understanding workloads