Archives of the TeradataForum
Message Posted: Tue, 22 Dec 2009 @ 22:21:47 GMT
Subj: | | Re: Finding Collected Stats That Are Equal 0 |
|
From: | | Victor Sokovin |
| Is it possible to query the data dictionary tables in such a way as to determine whether collected stats on a column has a value of 0.
Here is a sample output of a help stats statement that I executed. A select from dbc.ColumnStats returns a row but the column FieldStatistics is
in a Varbyte column which can not be formatted or viewed. Any suggestions? | |
It's a very popular subject! Have a look at the Forum Library:
www.teradataforum.com/attach.htm
Dieter has been providing updates on his stats viewing queries for all major releases:
10/19/2009 (Fri)
New stats query
Dieter Noeth
Attachment: .txt (16kb) save as: statistics_views_32+64.sql
.txt (31kb) save as: statistics_64-bit.sql
.txt (31kb) save as: statistics_32-bit.sql
.pdf (81kb) save as: Teradata Statistics.pdf
Victor
|