SQL Performance for Db2 Workload Index Advisor

Version 4
    Share This:

    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: 


    Article Number:


    Article Type:


      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles