15.00 - Distribution Demographics - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

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