Viewing the Object Use Count Report

Teradata Visual Explain User Guide

brand
Teradata Tools and Utilities
prodname
Visual Explain
vrm_release
16.10
16.20
category
User Guide
featnum
B035-2504-086K
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
  1. Open an execution plan, online or offline.
  2. To view details about all of the objects used in the plan:
    1. Right-click anywhere on the plan background.
      Object Details

    2. Select Object Use Count from the shortcut menu.
  3. To view details about a specific object:
    1. Right-click an icon.
    2. 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.