I have several tables that need to be cleaned up periodically, i.e. deleted and reindex (which also packs the table). This will take a while and I would like to display a progress bar to reassure the user that something is happening. I have two cases:

1. single table
2. two tables with related by ref integerity rules.

I use code like the following

DELETE ALL FOR expresion1 [AND expression2 [ AND ... ]]

with one to three expressions. Can this be done if so how. Would a SCAN loop be better (what are the performance hits). During testing I noticed deletion for tables with ref integrity rules seem to take a while.