Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

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


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


Subj:   Re: Find tables to run collect statistics
 
From:   Liao, Meijian

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020