15.10 - Row Count Avg. Row Size 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 Row Count/Avg. Row Size graph row distribution of the tables (and sub-tables) over the AMPs in the system. The sub-table for the table can be selected from the Standard box.

  • Click Graphs > Row Count/Avg. Row Size.
  • The Row Count/Avg. Row Size graph appears.

  • Click Reports > Row Count/Avg. Row Size.
  • The Row Count/Avg. Row Size report appears.

    1 Click Preferences > Row Count/Avg. Row Size.

    The Row Count/Avg. Row Size dialog box appears.

    2 Set the following options:

     

    Option

    Description

    AMPs Range

    Set the minimum and maximum AMP range.

    Row Count Range

    Set the minimum and maximum row count of a table or an index sub table for different AMPs.

    Source: Tables/Sub Tables

    Select the row distribution for the base table or for any of the available index sub tables.

    3 Click OK.