Contents Index Request-level logging Procedure profiling

ASA SQL User's Guide
  Monitoring and Improving Performance
    Performance analysis tools

Index Consultant


The Index Consultant recommends indexes that can help improve performance for large workloads or complex queries. It takes as input either a single query or a workload of queries, and recommends indexes to add to the database as well as unused indexes to drop.

The Index Consultant creates a set of virtual indexes in the database. It estimates query execution costs using those indexes to see which indexes lead to improved execution plans. The Index Consultant evaluates multiple column indexes as well as single-column indexes, and also investigates the impact of clustered or unclustered indexes.

For more information about the Index Consultant, see Index Consultant overview.


Contents Index Request-level logging Procedure profiling