Archives of the TeradataForum

Message Posted: Fri, 24 Feb 2006 @ 23:08:02 GMT

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

Statistics are not dependent on the machine configuration and are thus not affected by an event such as a reconfig. Statistics are built by creating 100 ranges, and then collecting some information for the values within that range.

Please remember that if your stats are old, the affect of those old stats may be magnified with a reconfig. Therefore, one might see an improvement by the collecting of stats within the system. If your stats are up to date, no collection of stats is necessary upon the reconfiguration of your system.

To see the data that gets collected when you run stats run the following command:

     help stats  column ;

or appropriate variations.

Please note that the output is different from the typical help stats command.

As you will see, there is nothing in there that will change with a reconfiguration of a system.

Jeff Pankow

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