The Object Global Use Count Report provides object use count information to help identify objects most often accessed. This information helps identify tables that have a high potential for performance improvements. This report is created when a workload in defined.
The following table explains the information provided in the report.
|
Column Name |
Description |
|
Database Name |
The name of the database that owns the object. |
|
Object Name |
Shows the object name. |
|
Object Type |
Indicates the object type, either Index, Table, or View. |
|
Columns |
Shows the columns (comma separated) that comprise the index. Note: This is an empty string for the table and the view object types. |
|
Index Type |
Shows the type of index. Note: This is an empty string for the table and view object types. |
|
Index Number |
Displays the index number. Note: This is Zero for the table and view object types. |
|
Global Use Count |
Displays the object use count of the objects available from the DBC.tables and DBC.indices views. |
|
Last Access Timestamp |
Displays the Last Access Timestamp. |
|
Recommended for drop |
This column is visible only when an index analysis is performed on a workload. This column shows “YES” if the index was recommended for DROP when the workload was analyzed. |
|
Insert Use Count |
Displays the Insert Use Count of the objects available from. Note: This column is available in the report only when connected to database version 14.10 or later. |
|
Update Use Count |
Displays the Update Use Count of the objects. Note: This column is available in the report only when connected to database version 14.10 or later. |
|
Delete Use Count |
Displays the Delete Use Count of the objects. Note: This column is available in the report only when connected to database version 14.10 or later. |