Viewing the Object Use Count Report - Visual Explain

Use this procedure to:

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

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 Details

b 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.