I have SET('DELETED') = OFF
I have indexes on DELETED() but not on !DELETED()
SYS(3054,1) reports full optimization.

>Bret:
>Do what is SET('DELETED')=?
>Do you have an index on !DELETED()?
>Have you turned on SYS(3054,1) to check rushmore optimization?
>
>>I need to delete a large portion of a parent table which has some child tables. RI is set to cascade these deletes. The delete processes very slowly and never seems to finish. It looks like
>>
>>DELETE FROM mytable WHERE mytable.group <> "rightgroup"
>>
>>I have indexes on all the keyfields and on the group field. The main table has about 5000 records, and the two child tables have a few thousand and several hundred each.
>>
>>I did this before without any trouble. I don't remember what I did differently, except that I was using vfp3 instead of vfp6.