Interesting difference in foreign key locking behavior between heap and index organized tables

(ilmarkerm) I hit this issue by accident, developers wanted to disable inserts to child table so they could perform some one-time maintenance operation, and this maintenance only affected one rown from the parent table (and all it’s children).

Read More - Register for Free Membership