Re: Delete rows faster ?
- From: "Syed Jaffar Hussain" <sjaffarhussain@xxxxxxxxx>
- To: oracledbam@xxxxxxxxxxx
- Date: Wed, 15 Nov 2006 10:47:02 +0300
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@xxxxxxxxxxx> 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
--
//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."
--
//www.freelists.org/webpage/oracle-l
Other related posts:
