Re: How to improve deletes on a non partitioned table with no indexes

One way to improve your performance would be to avoid the delete. Create a new table as select from the original table, excluding the rows you want to eliminate. Then, drop the original table and rename the new one to the original name.

Tim

"Subrahmanyam Arya" <avsrk_at_mailcity.com> wrote in message news:25c1993e.0306261313.6699a97_at_posting.google.com...
> Dear oracle gurus,
>
> I have created a non partitioned table with no indexes and stuffed in
> about 15 million rows. Using oracle 8.1.7.4 standard. I then deleted 1
> million and it took 1 solid hour. How can i reduce the time for
> deletes? Since oracle default locking behavior is row level locking, i
> changed to lock the table in exclusive mode before deleting. This dint
> help..
>
> Any clues,
> avsrk
Received on Fri Jun 27 2003 - 02:28:59 CEST