ASA SQL User's Guide
Monitoring and Improving Performance
Performance analysis tools
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.