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.
