Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 01 Apr 2003 @ 22:22:50 GMT

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

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 view DBC.COLUMNS).

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.

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