Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 26 Sep 2006 @ 14:18:36 GMT


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


Subj:   Re: Statistics expert needed
 
From:   Geoffrey Rommel

  I don't have time to figure out how to use dbc.columnstats right now. With that strange Varbyte(16383) from the TVFields table and all...  


Generally, you don't need to figure it out. If the varbyte column is null, there are no statistics; otherwise there are. But if you want to know on what date the stats were collected, you can use a UDF, like this one:

www.teradataforum.com/stat_dt.htm



     
  <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: 15 Jun 2023