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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Delete rows faster ?

Re: Delete rows faster ?

From: Syed Jaffar Hussain <sjaffarhussain_at_gmail.com>
Date: Wed, 15 Nov 2006 10:47:02 +0300
Message-ID: <97b7fd2f0611142347h2d88bd59m91ce8594b092da70@mail.gmail.com>


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-l
Received on Wed Nov 15 2006 - 01:47:02 CST

Original text of this message

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