Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Delete rows faster ?
Your question, raises, serveral questions.
How big is the table?
How many indexes does it contains?
How many rows are you going to delete?
If you are going to delete major percent of records, follow tom kyte procedure, like, copy the rows required into a temp table, truncate the source table and bring the data back from the temp table.
On 11/14/06, Dean Paul <oracledbam_at_hotmail.com> wrote:
> Hi,
> How to make delete rows faster ?
> thanks
>
> _________________________________________________________________
> Stay in touch with old friends and meet new ones with Windows Live Spaces
> http://clk.atdmt.com/MSN/go/msnnkwsp0070000001msn/direct/01/?href=http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Best Regards, Syed Jaffar Hussain 8i,9i & 10g OCP DBA I blog at :http://jaffardba.blogspot.com/ http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain ---------------------------------------------------------------------------------- "Winners don't do different things. They do things differently." -- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 15 2006 - 01:47:02 CST
![]() |
![]() |