I have an application that likes to delete 36 million rows out of the database per week. It's not a well written app. I really did not want to resort to rebuilding indexes but i seem to have no choice. We are not up 24 x 7. This is done with no users on. So yes please be careful. If you have any better ideas I'm certainly open to hear them.

Thanks

Hoz