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

Home -> Community -> Mailing Lists -> Oracle-L -> ** delete tuning

** delete tuning

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Thu, 22 Jun 2006 19:32:52 -0700 (PDT)
Message-ID: <20060623023252.978.qmail@web60720.mail.yahoo.com>


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 to the US (and 30+ countries) for 2/min or less.
--

http://www.freelists.org/webpage/oracle-l Received on Thu Jun 22 2006 - 21:32:52 CDT

Original text of this message

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