Table Usage Analysis Report - Teradata Index Wizard

Teradata Index Wizard User Guide

Product
Teradata Index Wizard
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2506
Product Category
Teradata Tools and Utilities

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.