Archives of the TeradataForum

Message Posted: Tue, 31 Aug 2010 @ 18:55:10 GMT

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

If you change those columns to NUPI, your update statement will run faster. But I guess the locking issue will not be resolved. Could you please try to lock the row for update. Even though row level lock locks more than one row basesd on row has, it might help you

Thanks,

Prasad

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