 |
 |
Archives of the TeradataForum
Message Posted: Tue, 06 Sep 2011 @ 14:49:46 GMT
| 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
| |
