Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 06 Sep 2011 @ 14:01:10 GMT


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


Subj:   Stats Refresh Post Expansion
 
From:   Machha Narayan Rao Naidu

HI All,

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.

Did Using T SET Helps if we can modify the details like No. Of AMP if Possible or if its stores it anywhere


Thanks

Machha



     
  <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