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.