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. |
@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...
|