DSXchange

Hi,

Can anyone provide me the pointers to run updates on a single table with multiple node config and avoid deadlock at the same time.

Many thanks in advance,
Vishal

Try partitioning on the primary keys. You could also remove duplicates (keep last sorted by date) to update with the most recent update.

Hash partition on the primay key ( you must have used in the update where clause), and set prpoer row commit size.