Archives of the TeradataForum

Message Posted: Fri, 18 Sep 2009 @ 23:30:34 GMT

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

Victor - Don't know why I was thinking in terms of DELETE, but yeah, the point is the same.

If the fields being updated don't have stats, the comparison would be "update in place" versus "insert to empty table + collect stats + make grants ," not just "update in place" versus "insert to empty table + make grants." (Leaving aside other issues like availability during the update, space limits, etc.)

Dave

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