You don't have a filter on bsmemo table so every record in bsmemo will be locked one by one.

>Thanks for looking that up. The k_seqno keys are unique autoinc keys in bsmemo. So I would assume that it would only need to lock the 3 records in bsmemo where the keys matched the 3 recs in c_memo. Am I correct or do I have it wrong?
>
>>Hi John,
>>
>>See Re: Why this DELETE is so slow? Message #989423 for explanation.