Database Reference
In-Depth Information
Figure 19-6.
Key lookup deadlock, Step 1
In the next step, both sessions are trying to acquire the lock on the rows in the other indexes and they would be
blocked, as shown in Figure
19-7
.
Figure 19-7.
Key lookup deadlock, Step 2