Archives of the TeradataForum

Message Posted: Thu, 08 Mar 2007 @ 09:34:59 GMT

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

Verify that you have collected stats on all of the pertinent columns. If stats are missing, the system will do a random amp scan to generate a temorary set. As it pick different amps, it may be getting significantly different information. The variation in the rendom samples could account for your CPU second variations.

Al Czajkowski
Partners Service Focus Team (alumni)

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