16.10 - Collecting Statistics - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

Use the COLLECT STATISTICS statement to define the table columns on which you want to collect statistics, for example:

COLLECT STATISTICS ON  database_name.table_name  COLUMN (column_1,  column_2  ...);

At minimum, you should collect statistics on the primary index (PI) of each table. For small tables (<100 rows per AMP) PI statistics may be sufficient.