Archives of the TeradataForum
Message Posted: Thu, 11 Nov 2004 @ 21:04:04 GMT
<-- Anonymously Posted: Thursday, November 11, 2004 15:51 -->
Would someone be able to explain to me the difference (or more so FieldStatistics) between the LastAlterTimestamp column verse the FieldStatistics column in DBC.TVFields?
I understand that FieldStatistics holds the index and column histograms. Inside the field is the (and I quote from Teradata RDBMS SQL Reference manual) "Time the statistics were collected." I have written SQL to extract this date but when compared to the LastAlterTimestamp date there is a big difference. It appears that the LastAlterTimestamp is actually holding the correct date as to when the last time we collected statistics on a particular column. It also appears that the LastAlterTimestamp date is the same as the date when doing a Statistics command in Teradata Administrator. So what date is kept with in the FieldStatistics column?
Thanks for any information!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|