Re: speedy deletes?

Hi,

I presume it is not a problem with FK checking and CASCADE deletes. If this is the case, then consider indexes, but this will probably be difficult to add online.

Otherwise, I think you need to look at array processing, which is available in PL/SQL as of Oracle8 (but it might be o8i) or PRO*C.

Also, you don't say which platform and versions you are working with.

Andrew

gplagge_at_hotmail.com wrote:

> Hi,
> We are trying to delete about 9 million rows from a table with over 40
> million rows, and which is activly in use (inserts, updates). The ideas
> we have come up with are verrrryyy slow. Any ideas on speeding them up?
> We have tried pl/sql looping through a million id numbers at a time
> (only deletes about 200,000 a day), regular deletes (forget it!), and
> cursor in pl/sql selecting a range of rows (slower than the first). We
> are deleting based upon an indexed field, and the explain plan says our
> cost is 5.
>
> Any other tips on speeding things up?
>
> Thanks,
>
> Gene Plagge
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---
Received on Mon May 24 1999 - 18:36:57 CDT