Recommendations for Large Tables - Teradata Database

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.