Recommendations for Large Tables - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
English (United States)
Last Update
Product Category

Recommendations for Large Tables

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)
  • Reference Information

    For more information on syntax and options for the COLLECT STATISTICS statement, see SQL Data Definition Language.