Archives of the TeradataForum

Message Posted: Mon, 14 Mar 2005 @ 20:15:13 GMT

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

Most likely the cause is either Hard Referential Integrity or Secondary index subtables.

Impossible to say without the table DDL, though.

And, blocking can occur if you update the same row hash mutliple times in the same input data set.

You haven't said if you were using the primary index for this update?

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