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.


    PRODUCT:

    SQL Performance for DB2


    APPLIES TO:

    Performance for Db2 SQL



    QUESTION:

    What is the SQL Performance for Db2 Workload Index Advisor and what is it used for?


    ANSWER:

     

    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:

    000248298


    Article Type:

    FAQ/Procedural



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