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.

Regards,

Victor