Statistics Details Graph - Teradata Index Wizard

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.