Archives of the TeradataForum

Message Posted: Fri, 07 Sep 2001 @ 15:06:05 GMT

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

Hi all,

3.5M recs were multiloaded into a table which already had 80M recs. Stats were collected on all required columns . Then we found that values in couple of columns are incorrect. To fix it, I took the 3.5M in temp table, fixed it and the originally multiloaded recs were replaced with the updated recs. (No additional recs)

Question is, Do I have to Collect Stat on all the columns again or the existing stats are still good?

Thanks in advance

Sudarsan

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