Posted 11 Sep 2014
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 Database 14.10, 15.0, or 15.10 software release levels. Some of these recommendations apply to releases earlier than Teradata Database 14.10 and some rely on new features available starting in Teradata Database 14.10. Statistics collection functionality in the Teradata Database works the same in 14.10, 15.0 and 15.10 releases. For greater detail on collecting statistics for Teradata Database 14.10, see the orange book titled: Teradata Database 14.10 Statistics Enhancements by Rama Krishna Korlapati. Contributors: Carrie Ballinger, Rama Krishna Korlapati, Paul Sinclair, September 11, 2014 |
Chandrasekhar,
The NoDot0Backdown setting needs to be changed to TRUE. The logic used by Analyze Jobs to detect staleness relies on UDI counts from USECOUNT logging in conjun...
|