Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DELETE rate is inconsistent!

Re: DELETE rate is inconsistent!

From: Pratap <pratap_fin_at_rediffmail.com>
Date: 11 Aug 2004 23:45:30 -0700
Message-ID: <830861d2.0408112245.4ed99a3a@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US