Re: Delete based on rowid
- From: rjamya <rjamya@xxxxxxxxx>
- To: troach@xxxxxxxxx
- 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@xxxxxxxxx> 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
Other related posts:
