Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DELETE rate is inconsistent!
Probably you are full scanning the table each time. So intially the
data is found at the "top" of the table and rows are deleted from the
"top". As you proceed in the loop, you need to scan the table deeper
and deeper, so it takes longer.
But yes, deleting 10 million rows is not a good idea. You could -
create table new_table nologging as select * from old_table where <<data not to be deleted>>
truncate old_table
rename new_table to old_table
Pratap Deshmukh
Cognizant Technology Solutions, India
www.Cognizant.com
Received on Thu Aug 12 2004 - 01:45:30 CDT