Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 06 Sep 2011 @ 14:49:46 GMT


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


Subj:   Re: Stats Refresh Post Expansion
 
From:   Victor Sokovin

  We are in a process to Schedule an Expansion of a 60TB Production Box. Post Expansion we are planning to collect stats on all the tables to make use of Distribution and Increased AMP's.  


  My Questions is If we go for a table by table Stats Refresh then it may take 3 Long Days to be done with all the tables, and in same time I don't think it will be really helpful to open the database for Loads and Other Users without stats Refreshed. So do we have any other option to Reduce the Stats Collection time here.  


Look, you can just join the party of optimists and do nothing, as per this old thread:

www.teradataforum.com/teradata/20060224_151739.htm

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