Workload Index Advisor component

The Workload Index Advisor component helps you create the correct indexes to minimize the cost of running a set of SQL statements.

Workload Index Advisor uses the Explain capability to extract and Explain the SQL from a user-defined workload; the component then analyzes the indexes to provide estimated costs and recommendations for additional indexes. Workload Index Advisor then validates the results by testing the recommendations with virtual indexes.

Note

The Workload Index Advisor component is available  only as part of the BMC Performance for DB2 SQL solution or the SQL Performance for DB2 solution (not as a stand-alone component).

This section contains the following topics:

Related topics

Recommending-indexes-for-workloads

Required-authorities-for-Workload-Advisor-Explains-and-the-Index-Advisor-feature

Workload-Access-Path-Compare-and-Workload-Index-Advisor-reference

SQL Performance solution components

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*