Use this procedure to do the following:
- Analyze how often objects are used in a plan
- Identify tables with the potential for performance improvements
- Analyze use of a specific object in a plan
- Delete obsolete or unused objects to improve system performance
- Open an execution plan, online or offline.
-
To view details about all of the objects used in the plan:
-
Right-click anywhere on the plan background.
Object Details
- Select Object Use Count from the shortcut menu.
-
Right-click anywhere on the plan background.
-
To view details about a specific object:
- Right-click an icon.
-
Select Object Use Count from the shortcut menu.
The Object Use Count report appears.
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. 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. 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. 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. This column is available in the report when connected to database version 14.10 or later.