Re: Delete based on rowid
From: rjamya <rjamya_at_gmail.com>
Date: Mon, 5 Oct 2009 07:26:09 -0400
Message-ID: <9177895d0910050426j5b0f55e1oae83145109436cb1_at_mail.gmail.com>
I think you are right ... when delete happens on a (indexed) column value, the index deletion should be quick but since rowid is used, a index ffs is probably the fastest oracle can do.
Date: Mon, 5 Oct 2009 07:26:09 -0400
Message-ID: <9177895d0910050426j5b0f55e1oae83145109436cb1_at_mail.gmail.com>
I think you are right ... when delete happens on a (indexed) column value, the index deletion should be quick but since rowid is used, a index ffs is probably the fastest oracle can do.
On Mon, Oct 5, 2009 at 7:10 AM, <troach_at_gmail.com> wrote:
> Since a btree index is organized by columns, not rowid (assuming its a
> btree index) oracle need to full scan it for that rowid. Since rowid points
> to the row in the table and not the index, it has no choice but to full scan
> the index. Someone please correct me if I'm wrong?
- Raj
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 05 2009 - 06:26:09 CDT