RE: Slow delete

Look for the indexes on the table . Drop all of them before executing delete. It has to write redo and rollback also. To avoid all these overheads simply truncate the table.  

Cheers

-----Original Message-----
From: David Turner [mailto:dturner_at_linuxcare.com] Sent: Monday, June 26, 2000 11:11 AM
To: Multiple recipients of list ORACLE-L Subject: Slow delete

Any idea why a delete of all the rows in a table might take hours when there are only 30,000 rows? There are no other users on the system. Rowlength is about 120.  

Dave Turner

--

Dave Turner, Senior Database Administrator, Linuxcare, Inc.

913.383.3052 tel, 913.579.3803 cel, 913.652.0687 fax, 877.443.9553 pager 

dturner@linuxcare.com,  http://www.linuxcare.com/
<http://www.linuxcare.com/> 

Linuxcare. Support for the revolution.