Re: Large set-based UPDATE

Paul wrote:
<<snip>>
>
>
> Sorry, I should have mentioned that this analysis has already been
> carried out.

Updated rows are locked until commit or roll back. That is fundemental.   There is no way around it. If your app does a SELECT. . . FOR UPDATE then you may consider doing a direct or table-to-table update. This way   you may be able to do the work faster or only lock the actual rows you are updating.

--
Andrew Allen