RE: Quicker way to Delete

From: Iggy Fernandez <iggy_fernandez_at_hotmail.com>
Date: Fri, 19 Jul 2013 13:47:05 -0700
Message-ID: <BLU165-W501FA2EB0832DDF951D626EB630_at_phx.gbl>



As Tom Kyte likes to say "Why is probably the right answer."

Why does this need to be done?
Why does this need to be done quickly?

See tkyte.blogspot.com/2005/05/why.html

> From: mark.powell2_at_hp.com
>
> Bala, this may be a dumb question but since no one should need to see these rows to be deleted, why the concern over how long the delete takes? Just write a little pl/sql to perform the delete with a commit every 10M of data size or so to limit the amount of undo related work other concurrent sessions will have to do and let the delete process run. I agree inserts and update tasks need to be fast, but deletes not so much in my opinion. Now I am not saying that inefficient code should be used or allowed to be used only that I do not see mass deletes as usually being a critical performance item. Rather I want a mass delete to be a low impact task. --
http://www.freelists.org/webpage/oracle-l Received on Fri Jul 19 2013 - 22:47:05 CEST

Original text of this message