Statistics Details Graph - Visual Explain

Teradata Visual Explain User Guide

Product
Visual Explain
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2504
lifecycle
previous
Product Category
Teradata Tools and Utilities

Statistics Details Graph

The Statistics Details graph shows the statistics of the specified column or index of the table.

To view the statistics collected on the table or sub-table

✔ Click Graphs>Statistics Details.

The Summary Statistics Information (Statistics Details) graph appears.

The Statistics Details graph shows three levels of details of the selected table. The following table shows the icons used for each level and explains the level.

 

Table 29: Statistics Details Graph Icon Descriptions 

Type of Detail

Icon

Description

Summary Statistics Information

Shows a summary of the statistics on the selected tables.

Equal Height Statistics Information

Shows equal heights statistics.

High-Biased Column Statistics

Shows high bias column statistics.

To view the report form of this graph

1 Click Reports>Statistics Details.

The Summary Statistics Information report appears.

To change the settings of the statistics details graph

1 Click Preferences>Statistics Details.

The Statistics Details Settings dialog box appears.

2 Set the following options:

 

Option

Description

Select Type

  • Summary Stats: The summary of the statistics on the selected tables.
  • Equal Height: Specifies equal heights statistics.
  • High Bias: Specifies high biased column statistics.
  • Interval Range

    Set the minimum and maximum range of intervals in the frequency distribution for the column or index.

    Mode Frequency

    Check to display the number of rows in the interval that have a modal value for the column or index.

    Total Rows

    Check to display the total number of rows in the table.

    Unique Values

    Check to show the unique values for the column on which statistics were collected.

    Max Value

    Check to show the highest value for the specified column or index in the specified table.

    Mode Value

    Check to show the most frequently occurring value or values for the column or index in the specified table.

    Source

  • Fields: Select from the list of fields on which the statistics are available.
  • Columns: Select the columns that contain the index.
  • 3 Click OK.