16.10 - Recommendations for Large Tables - 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)

For best results on large tables, collect SUMMARY statistics only on non-partitioned tables. Other recommendations for large tables include collecting statistics on:

  • All indexed columns
  • All frequently joined columns
  • Columns frequently referenced in WHERE clauses, particularly if the column contains very skewed, nonunique data
  • The system-derived column PARTITION (for all row and column-partitioned tables)