Archives of the TeradataForum

Message Posted: Wed, 20 Feb 2008 @ 09:33:31 GMT

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

Hi Martin,

one reason could be that new data had been loaded to the table after the stats had been collected. Stats are not refreshed automatically and therefore the recommendation is that you should recollect stats if ~5% of the data changed. But this is not an absolut recommendation. As it is only required to refresh the stats in case the demographic changed - which might have happened in your case.

Uli

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