Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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.


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019