Re: UPDATE on 20 Million Records Transaction or not?

[luis . roberto]

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 update between smaller transactions.