Thanks Adrian,
> You could break it down into multiple transactions if there is way to specify ranges of records.
Say I couldn't break it up, would it be faster in or out of the transaction?
It depends whether you have concurrent transactions using the table. If you do, I think it would be better to split the
updatebetween smaller transactions.