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 tuning

Re: ** delete tuning

From: eagle fan <eagle.f_at_gmail.com>
Date: Fri, 23 Jun 2006 13:16:17 +0800
Message-ID: <4415a5ed0606222216t28bbe565mefa25b17612558ad@mail.gmail.com>


hi Joshi:

You can try bulk delete.

On 6/23/06, A Joshi <ajoshi977_at_yahoo.com> wrote:
>
> Hi,
> In one of my programs : I am doing a lot of deletes for one key
> existing in many tables. I have to visit each table and delete the row for
> the key. This process is real slow. Are there any parameters or settings to
> set , init or otherwise to make delete faster. Or any other guideline? The
> version is 8.1.7. Thanks
>
> ------------------------------
> Yahoo! Messenger with Voice. Make PC-to-Phone Calls<http://us.rd.yahoo.com/mail_us/taglines/postman1/*http://us.rd.yahoo.com/evt=39663/*http://voice.yahoo.com>to the US (and 30+ countries) for 2/min or less.
>
>

-- 
Eagle Fan

Oracle DBA

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jun 23 2006 - 00:16:17 CDT

Original text of this message

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