15.10 - Object Global Use Count Report - Teradata Index Wizard

Teradata Index Wizard User Guide

prodname
Teradata Index Wizard
vrm_release
15.10
category
User Guide
featnum
B035-2506-035K

The Object Global Use Count Report provides object use count information to help identify objects most often accessed. This information helps identify tables that have a high potential for performance improvements. This report is created when a workload in defined.

  • Select Reports > Create Workload > Object Global Use Count Report
  • The following table explains the information provided in the report.

     

    Column Name

    Description

    Database Name

    The name of the database that owns the object.

    Object Name

    Shows the object name.

    Object Type

    Indicates the object type, either Index, Table, or View.

    Columns

    Shows the columns (comma separated) that comprise the index.

    Note: This is an empty string for the table and the view object types.

    Index Type

    Shows the type of index.

    Note: This is an empty string for the table and view object types.

    Index Number

    Displays the index number.

    Note: This is Zero for the table and view object types.

    Global Use Count

    Displays the object use count of the objects available from the DBC.tables and DBC.indices views.

    Last Access Timestamp

    Displays the Last Access Timestamp.

    Recommended for drop

    This column is visible only when an index analysis is performed on a workload. This column shows “YES” if the index was recommended for DROP when the workload was analyzed.

    Insert Use Count

    Displays the Insert Use Count of the objects available from.

    Note: This column is available in the report only when connected to database version 14.10 or later.

    Update Use Count

    Displays the Update Use Count of the objects.

    Note: This column is available in the report only when connected to database version 14.10 or later.

    Delete Use Count

    Displays the Delete Use Count of the objects.

    Note: This column is available in the report only when connected to database version 14.10 or later.