Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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)


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