Archives of the TeradataForum

Message Posted: Fri, 07 Apr 2006 @ 14:28:08 GMT

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

Upsert is more efficient than a delete followed by an insert in Mload.

At the very least Mload is dealing with less rows in the acquisition phase, and less writes to the work tables.

jdg

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