Contents Index Understanding the analysis Assessing the recommendations

ASA SQL User's Guide
  Working with Database Objects
    Working with indexes
      Understanding the Index Consultant

Understanding the recommendations

The Index Consultant provides a set of tabs with the results of a given analysis. The results of an analysis can be saved for later review.

Summary tab 

The Summary tab provides an overview of the workload and the analysis, including such information as the number of queries in the workload, the number of recommended indexes, the number of pages required for the recommended indexes, and the benefit that the recommended indexes are expected to yield. The benefit number is measured in internal units of cost.

Recommended Indexes tab 

The Recommended Indexes tab contains data about each of the recommended indexes. Among the information provided is the following:

Requests tab 

The Requests tab provides a breakdown of the impact of the recommendations for individual requests within the workload. The information includes the estimated cost before and after applying the recommended indexes, as well as the virtual indexes used by the query. A button enables you to view the best execution plan found for the request.

Updates tab 

The Updates tab provides a breakdown of the impact of the recommendations.

Unused Indexes tab 

The Unused Indexes tab lists indexes that already exist in the database that were not used in the execution of any requests in the workload. Only secondary indexes are listed: that is, neither indexes on primary keys and foreign keys nor unique constraints are listed.

Log tab 

The Log tab lists activities that have been completed for this analysis.


Contents Index Understanding the analysis Assessing the recommendations