15.10 - Statistics Details Graph - Teradata Index Wizard

Teradata Index Wizard User Guide

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

The Statistics Details graph shows the statistics of the specified column or index of the 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 36: 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.

  • Click Reports > Statistics Details.
  • The Summary Statistics Information report appears.

    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.