Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 18 Jun 2004 @ 07:48:53 GMT

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

Subj:   Re: Can we check stats automatically
From:   Victor Sokovin

  Is there a way to check stats on tables automatically. Something happened and the stats on one our tables went to all zeros(still do not know why!), which affected performance tremendously. At that time we checked and readded stats. But is there a way, may be a cron job, that can check stats on tables and send warnings if stats are missing?  

I am not aware of such an off-the-shelf job but it should not be too difficult to schedule a script which would analyze the output of

HELP STATISTICS <table_name> ;

for all the tables involved in the application. Such analysis should probably be application specific because some tables are not modified for months and stats may be pretty old but some other tables would require daily refreshes etc.



  <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: 15 Jun 2023