Archives of the TeradataForum
Message Posted: Tue, 22 Dec 2009 @ 20:00:04 GMT
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?
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' ;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|