15.10 - Table Scan 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 Scan Report provides general information about the usage of a table including table cardinality, AMP usage, and geography information in the workload. Specifically, the report provides details about how the tables in the workload are used in the different queries. For example, the report allows you to check whether a given table is duplicated on the AMPs or is hash-redistributed, etc. This report is created when a workload is defined.

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

     

    Column Name

    Description

    Database Name

    Shows the name of the database used to generate the report.

    Table Name

    Shows the table name.

    Rows Estimate

    Estimates the number of rows in a table.

    Access Type

    Shows the type of access made on the table. Types include:

  • All AMP Retrieve
  • Single AMP Retrieve
  • Two AMP Retrieve
  • Group AMP Retrieve
  • Geography

    Shows the geography of the relation. For example, it tells if the relation is hash re-distributed, built locally or duplicated to all AMPs.

    Statement Text

    Shows the text of the SQL statement for the individual table.