15.10 - Table Usage Analysis 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 Table Usage Analysis Report shows information on how often the table is accessed within the workload. A table with a high access number may have more potential for an index improvement. On the other hand, a table with a low access number may not need to be analyzed because its potential for a performance gain is limited. This report is created when a workload is defined or after the index analysis process.

  • Select Reports > Current Workload > Table Usage Report.
  • The following table explains the information provided by this report.

     

    Column Name

    Description

    Database Name

    Shows the name of the database.

    Table Name

    Shows the name of the table.

    Statement Access Count

    Indicates the number of statements in the workload that access a specific table.