![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Sat, 29 Jan 2005 @ 19:01:20 GMT
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
| |