LONG-running DELETE -- please help

From: dib42700 <dib42700_at_glaxowellcome.com>
Date: 16 Nov 2002 21:21:19 GMT
Message-ID: <01c28db5$3ab40af0$6601a8c0@us0097739>

The following Oracle DELETE statement is EXTREMENTLY long-running:

   delete from tmmAdministratorInitiative    where InitiativeID = 1
   and employeeid = '00701280K'

Here's the DDL for the table:

   CREATE TABLE TMMADMINISTRATORINITIATIVE (

   EMPLOYEEID                      VARCHAR2(20) NOT NULL


   ,INITIATIVEID                   NUMBER(10) NOT NULL

   ,CRTDT                          DATE

   ,CRTUSR                         VARCHAR2(50)

   ,MODDT                          DATE

   ,MODUSR                         VARCHAR2(50)

,CONSTRAINT U_ADMIN_INITIATIVE UNIQUE ( EMPLOYEEID, INITIATIVEID )
,CONSTRAINT FK_EMPLOYEEID_2 FOREIGN KEY ( EMPLOYEEID ) REFERENCES
TBLEMPLOYEE ( EMPLOYEEID )
,CONSTRAINT FK_INITIATIVEID_2 FOREIGN KEY ( INITIATIVEID ) REFERENCES
TBLINITIATIVE ( INITIATIVEID ) ON DELETE CASCADE    );

There's no primary key because this is a"linkage" table in a many-to-many relationship.

There are just two rows in the table!

Any help understanding why the DELETE statement takes so long would be greatly appreciated! Received on Sat Nov 16 2002 - 15:21:19 CST