Archives of the TeradataForum

Message Posted: Thu, 11 Nov 2004 @ 21:04:04 GMT

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

<-- 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!

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