We are in the process of testing scripts that would delete approximately 30,000 rows from our database. We are running Oracle8i on an NT server.

We are finding that it is taking about 5 minutes to delete 100 rows. The processor is running at 100% capacity. Does anyone have any ideas about how we could speed this up?

If there is a high level of fragmentation in the indexes could this be causing a slowdown since it would take longer to locate each row to be deleted?

Thanks for any ideas you may have!!