Viewing Object Use Count Report
Use this procedure to:
To display the Object Use Count report for a plan or plan icon
1 Open an execution plan, online or offline.
2 Do one of the following:
i Right‑click anywhere on the plan background.
i Right‑click anywhere on the plan background. Figure 59: Object Detailsii Click Object Use Count from the shortcut menu.
i Right‑click on an icon.
i Right‑click on an icon.ii Click Object Use Count from the shortcut menu.
The Object Use Count report appears.
Figure 60: Object Use Count Report
Column Name |
Description |
Database Name |
The name of the database that owns the object. |
Object Name |
The object name. |
Object Type |
The object type: index, table, or view. |
Columns |
The comma‑separated columns that make up the index. Note: For Table and View object types, this column is empty. |
Index Type |
The type of index (for example, Primary Index). |
Object Use Count |
The object use count of the objects available from the DBC.tables and DBC.indices views. |
Last Access TimeStamp |
A timestamp indicating the last time the object was accessed. |
Insert Use Count |
Displays the Insert Use Count of the objects available from. Note: This column is available in the report when connected to database version 14.10 or later. |
Update Use Count |
Displays Update Use Count of the objects. Note: This column is available in the report when connected to database version 14.10 or later. |
Delete Use Count |
Displays Delete Use Count of the objects. Note: This column is available in the report when connected to database version 14.10 or later. |