Re: Delete based on rowid

From: rjamya <>
Date: Mon, 5 Oct 2009 07:26:09 -0400
Message-ID: <>

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, <> 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
Received on Mon Oct 05 2009 - 06:26:09 CDT

Original text of this message