Prevent Deadlock in Teradata.

 

Minimizing Deadlock by Specifying the LOCKING Request Modifier

You can use the LOCKING request modifier to improve performance and reduce conflicts in the following ways.

Using the NOWAIT option to abort a transaction if a lock cannot be granted immediately.

Using the LOCKING ROW FOR WRITE syntax to eliminate the chance of a deadlock during an update when multiple transactions select and then update the same row.

Applying a higher or lower severity of lock than that normally applied by the Lock Manager.