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

Home -> Community -> Usenet -> c.d.o.server -> How Oracle find rows to delete in an index

How Oracle find rows to delete in an index

From: Bruno Jargot <see_at_reply-to.invalid>
Date: Tue, 17 Aug 2004 19:56:31 +0200
Message-ID: <1giohei.1r2gls4a95a8sN%see@reply-to.invalid>


Hello,

I hope it's not a stupid question :

How do Oracle find the row to delete in an index ?

Example :
A table T with 2 indexes I1 on T(C1) and I2 on T(C2)

Suppose we execute the following request : delete from T where C1 = 'foobar';

With the index I1, Oracle will find the rowid of the line to delete.

It already knows the row to delete in the index I1 and it knows the rowid of the row in the table.
But how will Oracle find the corresponding row to delete in the index I2 ?

Will Oracle do a range scan in the index I2 after finding the value of C2 in the table ?

Do I miss something ?

Thanks in advance for any helps or pointers.

-- 
Bruno Jargot
Received on Tue Aug 17 2004 - 12:56:31 CDT

Original text of this message

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