Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: What information does 'collect statistics' store?
From:   Narayan Murthy K S

  It stores the actual number of rows for certain values (including the most frequently occurring value within each percentile), but not for every value.  

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.


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020