Archives of the TeradataForum
Message Posted: Tue, 06 Sep 2011 @ 14:01:10 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|