Archives of the TeradataForum
Message Posted: Tue, 01 Apr 2003 @ 22:22:50 GMT
| Subj: || || Re: Date of Statistics |
| From: || || John Hall |
Actually, if the design of your table is stable, then you can probably just use the LASTALTERTIMESTAMP=A0field in DBC.TVFIELDS (or the
The column LASTALTERTIMESTAMP will be updated when the column in question is either changed by an ALTER TABLE, COMMENT or COLLECT
STATISTIC statement. If the only thing that is happening to the specific column is a COLLECT STATISTIC statement, then LASTALTERTIMESTAMP
can be said to contain a timestamp for the last COLLECT statement.