Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> How Oracle find rows to delete in an index
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 JargotReceived on Tue Aug 17 2004 - 12:56:31 CDT
![]() |
![]() |