Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Sat, 29 Jan 2005 @ 19:01:20 GMT


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


Subj:   Re: Record count stored in Data Dictionary
 
From:   Dieter Noeth

Donald Stubbs wrote:

  It's time to post the stats queries again ;-)  


  As a BIG fan of your stats queries, are there changes from the last posting?  


     2004-11-08 dn added StatsVersion
                   fixed SampleSize for pre-V2R5 stats, now displays 100%
     2004-11-15 dn added version based on base tables to display CollectDuration,
                   modified/reformatted source code

In www.teradataforum.com/teradata/20041111_210404.htm Anomy Anon wrote about the difference between LastAlterTimestamp and the Stats time, so i added CollectDuration, but i don't know if it's correct, because sometimes it's a negative value (probably only for Pre-V2R5 stats)


Dieter



     
  <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