Collect Statistics in Teradata – The Evaluation
After collecting every combination considered necessary and helpful, you can check the result of the collected statistics on a table by looking at
- the time it took to collect and the then prevailing circumstances
- the collection results
Consider the lengthier collection time when planning maintenance and scheduling, even within regular or optimal conditions. Simplify and maintain the collection method, particularly for smaller tables that require only a few seconds.
If there are collected combinations with similar result sets, some may not provide additional information about the table content.
Get the complete Teradata tuning book, free
Teradata Query Performance Tuning: The DWHPro Guide
By Roland Wenzlofsky & Artemios Vogiatzis
206 pages on statistics and demographics, access paths and indexes, query execution plans, and joins. Get the full PDF and practical Teradata updates from DWHPro.
Confirm your email to receive your download link. Privacy policy. Unsubscribe in any newsletter.
About the free bookExamine this excerpt from a sequence of collectible pairings:
…
14/03/10 09:01:35 462,452,442 L_ID,C_DT
14/03/10 09:02:48 462,455,048 L_ID,C_DT,CLASS
…
The historical distinct counts are nearly equal, but this alone does not establish that the three-column statistic is redundant. Correlated predicates, value distributions and workload estimates may benefit from it. Compare plans and estimates for representative queries before removing the statistic, and retain a way to restore it.
There is still an advantage in such an “over-collection”: if the result comes as a surprise, it can be the one trigger that starts a data quality investigation earning you the fame of finding it first!
See also:
Teradata Collect Statistics Using Sample
Collect Stats in Teradata
Teradata Statistics Basics
All you need to know about Teradata Statistics
Need help with query performance or platform costs?
Diagnose plans, skew, spool pressure and expensive workloads. Agree a baseline and acceptance criteria before making changes.
Get the complete Teradata tuning book, free
Teradata Query Performance Tuning: The DWHPro Guide
By Roland Wenzlofsky & Artemios Vogiatzis
206 pages on statistics and demographics, access paths and indexes, query execution plans, and joins. Get the full PDF and practical Teradata updates from DWHPro.
Confirm your email to receive your download link. Privacy policy. Unsubscribe in any newsletter.
About the free book