Archives of the TeradataForum

Message Posted: Wed, 30 May 2012 @ 14:40:33 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi All,

Can anyone explain what the fieldstatistics column in dbc.columnstats. when i check with below query it gave feildstatistics001.dat.. What information its has.

FYI:

     sel  * from   dbc.columnstats where databasename ='XXX'  and
     tablename='XXXX'

     1   XXX   XXXX   accs_meth_id   D    8   ------------9.   12   0
     FieldStatistics001.dat   1,025   2   XXX   XXXX   service_no
     CV   35   X(35)   ?   ?   FieldStatistics002.dat   1,026

regards,

Sridhar kola

	<Prev	Next>		<<First	<Prev	Next>	Last>>