Archives of the TeradataForum

Message Posted: Fri, 16 Mar 2012 @ 08:50:43 GMT

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

Hi JAMES,

You can simply use the table size of the tables to find out which table has been changed.

Such as you remembered the table size of your tables first time you collected stats. The second time, Using the current table size to compare with last table size, if it has changed for a certain percent(such as 10%), you can try to recollect stats.

Best Regards!

Meijian Liao
Professional Service,Teradata Corporation(TDC)

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