|
|
Archives of the TeradataForum
Message Posted: Fri, 24 Feb 2006 @ 19:32:01 GMT
Subj: | | Re: Adding Nodes to a System: Re-Collection of Stats necessary? |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Friday, February 24, 2006 14:07 -->
Diane Wilson wrote:
| In the case of a Teradata software upgrade it is recommended to run collect statistics to update Optimizer with any change in the newer
release of software. | |
| Otherwise, I can't see why you would need to collect stats after adding new nodes - stats are about the table, the no of rows on your
tables will stay the same,as well uniqueness ratio etc - so don't see need to recollect. | |
What other operations do any of you perform after an upgrade?
Thanks...
| |