Archives of the TeradataForum

Message Posted: Tue, 15 Mar 2005 @ 14:04:20 GMT

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

That is likely the cause of your blocking.

My money says you remove the trigger, and you eliminate the blocking.

Statement level after update triggers will upgrade your row hash write lock to a table level write lock when they run.

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