Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 13 Jan 2012 @ 23:09:23 GMT


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


Subj:   Re: When to recollect stats?
 
From:   Dieter Noeth

Joe Gleason wrote:

  Do you want to recollect on row counts or perm space changes? Can you list the pros and cons of each? I collect on currentperm changing by more than 10% but would like to hear why row counts might be better...  


To base it on perm space you need to maintain a space history (of course this might be already in place) and table size changes when an index is added/dropped.

Row count is based on previous stats (no history neccessary) and for partitioned tables it can detect when the number of partitions or the maximum partition row count changed.


Dieter



     
  <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