Richard Pendered wrote:

> Can anyone recomend the fastest way of deleting all of the rows in a table.
> I don't want to drop and create (or recreate) as some stored procs need this
> table.

Set indexes inactive before "delete from THETABLE".
Do your indexes have low selectivity? If so, improving the selectivity
(e.g. by appending the PK to the index) may make the delete "fast enough"
without deactivating the indexes.


Regards,
Aage J.