Parellel Updates

[vss]

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

[anntaylor]

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

[keshav0307]

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