Is there any thumb rule, which says which method to use when. 'cos, I do these deletions in a batch program and some times the data files will be of varing sizes (40- 60%) of the existing table size.
Having a thumb rule, I will check for the conditions and use the suitable statement.

Badrinath