Warning: Creating default object from empty value in _dxcontentbanner_set_details_blog() (line 206 of /appl1/devx/drupal/sites7/all/modules/devx/modules/dxcontentbanner/dxcontentbanner.inc).
Subscribe to Blog content and comments for dnoeth Blog Archive: December 2011
How to decode the binary statistics stored in dbc tables
Posted 27 Dec 2011

Collected statistics are a valuable source of information in Teradata, not only for the optimizer, but also for developers or DBAs. Spotting outdated statistics (which might lead to bad optimizer plans) and implementing/monitoring a stats recollection process are common tasks, which need the current statistics as input.

 65316 views 28 comments
@Hibellm: You only need this query if you're on a release lower than TD14. Since TD14 there's a builtin view returning similar information, dbc.StatsV, try this instead, every u...
dnoeth