About SUMMARY Statistics - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

Teradata recommends collecting SUMMARY statistics for both partitioned and non-partitioned tables. This is a fast way to collect the current total number of rows in a table. Collecting SUMMARY statistics is useful if collecting full statistics is too expensive. Collecting SUMMARY statistics also allows more accurate extrapolation from previously collected full statistics, allowing resource-intensive full statistics collection to be delayed longer.