|
|
Archives of the TeradataForum
Message Posted: Tue, 22 Dec 2009 @ 20:00:04 GMT
Subj: | | Finding Collected Stats That Are Equal 0 |
|
From: | | Pugliesi, Anthony J |
Forum:
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?
Thanks,
Tony Pugliesi
help statistics on the_database.the_tablename
Date Time Unique Values Column Names
11/16/2009 12:36:40 0 The_Column_Name
sel *
from dbc.ColumnStats
where databasename = 'the_database' and tablename = 'the_table'
;
| |