Tags for statistics collection
Statistics Collection Replication
Collecting stats gives the PE an idea of the data distribution of the tables involved in a query and come up with an optimised plan for query execution. Stats collection is a highly CPU intensive active.
statistics collection
Statistics collection
I have few doubts regarding statistics collection.   1. Does the order of columns used in collect stats command important?  2. Consider the following scenario    Table A joins with Table B based on Col1 and Col2 and Table A joins with Table C based on Col1, Col2 and Col3.
statistics collection statistics performance
Statistics collection recommendations – Teradata 14.0
Statistical information is vital for the optimizer when it builds query plans.  But collecting statistics can involve time and resources.  By understanding and combining several different statistics gathering techniques, users of Teradata can find the correct balance between good query plans and the time required to ensure adequate statistical information is always available. This recently-updated compilation of statistics collection recommendations are intended for sites that are on any of the Teradata 14.0 software release levels.   Some of these recommendations apply to releases earlier than Teradata 14.0, however some rely on new features available only in Teradata 14.0. Contributors:  Carrie Ballinger, Rama Krishna Korlapati, Paul Sinclair, February 12, 2013
database statistics collection
New opportunities for statistics collection in Teradata 14.0
Teradata 14.0 offers some very helpful enhancements to the statistics collection process.   This posting discusses a few of the key ones, with an explanation of how these enhancements can be used to streamline your statistics collection process and help your statistics be more effective.
database statistics statistics collection histograms teradata 14.0
Teradata 13.10 Statistics Collection Recommendations
Statistical information is vital for the optimizer when it builds query plans.  But collecting statistics can involve time and resources.  By understanding and combining several different statistics gathering techniques, users of Teradata can find the correct balance between good query plans and the time required to ensure adequate statistical information is always available. The following statistics collection recommendations are intended for sites that are on any of the Teradata 13.10 software release levels.  Most of these recommendations apply to releases earlier than Teradata 13.10, however some may be specific to Teradata 13.10 only.
database statistics statistics collection