Information
Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Index component


The Index component automatically collects and displays actual access counts for each unique SQL statement (table and index, and predicate usage frequencies).

A What-If Index analysis lets you model changes to indexes. The Index component provides on-demand, dynamic data collection of index dependencies and catalog statistics. Table and index reports provide quick access to listings of the most-used object based on getpage volume or ratio.


Warning

Important

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

This section contains the following topics:


 

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

SQL Performance for DB2 13.1