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.

Note

The Index 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

Using-the-Index-Component

Index-Component-reference

SQL Performance solution components


 

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