Archives of the TeradataForum

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

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

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>>