Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 24 Mar 2006 @ 22:49:30 GMT


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


Subj:   Re: Automatic statistics management
 
From:   Victor Sokovin

  Here is an example of what we used to refresh table using > 10% change within a week as guide.  


My understanding is that this 10%-rule is meant for the actual number of changes in the values of a column, not the table size per se. Your algorithm is definitely useful but it is very far from covering all cases. I don't think it is possible to cover them from a pure DBA perspective. In my opinion, data owners should be responsible for statistics collection schedules. They know when important data changes take place and should provide the list of columns, indexes etc, together with the schedules.


Regards,

Victor



     
  <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: 15 Jun 2023