>See SYS(3054) report below.
>I still don't think it has anything to do with Rushmore. It runs fast with one data session. Also if you replace "DELETE cctskrso" with "SELECT *" it also runs fast.
>
>But then again, it doesn't use TaskId tag at all. Unless it is with this command:
>DELETE FROM ccTskRso WHERE TaskId = 10000
>
>I am puzzled...
>
>
>"DELETE cctskRso FROM ccTskrso Join cctask ON ccTskRso.taskid = ccTask.Id WHERE ccTask.cid = 1000
>
>Rushmore optimization level for table cctskrso: none
>Using index tag Cid to rushmore optimize table cctask
>Rushmore optimization level for table cctask: full
>Joining table cctskrso and table cctask using index tag Id"

Andrew, what about flocking the table first?

if flock('ccTskrSo')
    DELETE ...
endif