This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
SQL Performance for DB2
Performance for Db2 SQL
What is the SQL Performance for Db2 Workload Index Advisor and what is it used for?
The Workload Index Advisor component helps you create the correct indexes to minimize the cost of running a set of SQL statements.
The 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.
Index Advisor can gather workload data from the following sources:
■ APPTUNE archived trace data sets
■ BMC Performance Database
■ DB2 catalog
■ Statement CACHE
■ DBRM libraries
■ SQL text data sets
See the attached document for complete details including examples and usage: