Hi, Seema, I f the issue is still current, deletions taking too much time may be caused by not indexed foreign keys. If the child table does not have an index on a column which references the parent one, to delete even a single row Oracle performs full table scan which locks the table, too. It is a serious issue when tables are huge. So I'd check for unindexed foreign keys first. Regards, Sergey Babich
-----Original Message----- Sent: Thursday, January 10, 2002 6:05 PM To: Multiple recipients of list ORACLE-L Subject: HOW TO MAKE DELETION FAST Hi I want to delete milliuns of row from one table.that table have 2 constraints and some indexes.What to do for fast deletion.When ever I run deletion it takes time too. Thanks -Seema _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).