RE: HOW TO MAKE DELETION FAST

From: Babich , Sergey <SBabich_at_handexmail.com>
Date: Fri, 11 Jan 2002 10:46:52 -0800
Message-ID: <F001.003EE0E0.20020111103242@fatcity.com>

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: oracledbam_at_hotmail.com

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: ListGuru_at_fatcity.com (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: SBabich_at_handexmail.com

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: ListGuru_at_fatcity.com (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). Received on Fri Jan 11 2002 - 12:46:52 CST