Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

Re: ** delete tuning

Stefan Knecht

2006-06-23

Replies:

Assuming you have foreign keys that point to your child records, are these columns indexed ?

Just my 2cents


Stefan

On 6/23/06, A Joshi <ajoshi977@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 to the US (and 30+ countries) for 2ยข/min or less.


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.