Use this procedure to:
1 Open an execution plan, online or offline.
2 Do one of the following:
To view details about all of the objects used in the plan:
a Right‑click anywhere on the plan background.
Figure 58: Object Detailsb Click Object Use Count from the shortcut menu.
To view details about a specific object:
a Right‑click on an icon.
b Click Object Use Count from the shortcut menu.
The Object Use Count report appears.
Figure 59: 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. |