Thank you for your comments. Sorry for the late reply.
From: Kirk Wolak Sent: Friday, November 25, 2022 6:12 PM
> My first question is why are you not using "WHERE CURRENT OF" cursor_name?
I thought that cursors are preferred for manipulating large numbers of rows.
So I did not consider using cursors in this test case because each process manipulates only one row.
However, assuming general usage, I thought it would be preferable to use a cursor, as you pointed out, because it might
resultin fewer table accesses.
I didn't have that knowledge.
> But effectively, you are locking the row and that is the row you want to update (the current row of the cursor).
> I wonder if that addresses the problem...
I tested it with a cursor, but there was still a problem..
I will attach the script used for the test, though it will be simple.