Archives of the TeradataForum

Message Posted: Wed, 06 Mar 2002 @ 14:49:43 GMT

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

I have a question here:
How do you make out what gets actually stored - because the place where these statistics gets stored w.r.t a column is in DBC.TVFIELDS column "FieldStatistics" which is of type VARBYTE(16383). How would you interpret this information which is stored in terms of bytes.

This is what i tried :

create table t1(a int,b int);

** populate the table with 10 rows, then collect statistics on t1 column a;

** then "select Fieldstatistics from dbc.tvfields" based on the tableid and databaseid of the table i had created.

It displayed information in bytes - i couldn't draw any conclusion from it.

Narayan.

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