Distribution Demographics - Teradata Database

Distribution Demographics

Among the column demographics retrieved by the COLLECT STATISTICS (Optimizer Form) statement some figures are very useful for monitoring how evenly your primary index columns distribute rows across the AMPs.

The relevant demographics are the following.

Number of distinct values within a primary index column

Number of rows per distinct value

Number of rows partly null

Number of rows all null

Typical number of rows per distinct value