Re: Delete based on rowid
Date: Mon, 5 Oct 2009 07:26:09 -0400
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?