You can try to use the same WHERE clause in the "select count(*) ..." as
you used in the "delete ...". I don't think it is necessary to touch
all rows.

Regards,
Aage J.


Bill Morrison wrote:

> That may very well be the solution.
> Now, the tables I'm dealing with hold more than a million records, and the
> application is doing real time (more or less) data capture. Is there a
> different way to "touch" the deleted records so they go away?
>
> -----Original Message-----
> I think Ann mentioned once, to issue a count(*) once in a while
> reclaims the database space.