>Hugo,
>Actually just tried it myself and yes it does help - once you FLOCK it it works fast. But... How you explain that DELETE (or UPDATE) that doesn't involve a nested SELECT also works fast?
>I need to understand what makes it slow. And I am not really thrilled with having to use FLOCK as it'll bring up other issues in the app.
>
>--Andrew
Can you post SYS(3054) for this:
DELETE cctskRso FROM cctask WHERE ccTskRso.taskid = ccTask.Id and ccTask.cid = 1000