Re: Delete based on rowid
Date: Mon, 5 Oct 2009 11:10:46 +0000
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? Sent from my Verizon Wireless BlackBerry
From: DBA Deepak <oracle.tutorials_at_gmail.com> Date: Mon, 5 Oct 2009 16:04:09
Subject: Delete based on rowid
Have a simple question.
When we delete a row based on rowid from an indexed table, how the index entry gets deleted?
DELETE t WHERE rowid='<some rowid>';
Am asking this because in my case Oracle is doing a full index scan. Can we say deleting an indexed table based on rowid may not be the fastest way of deleting a row?
http://www.freelists.org/webpage/oracle-l Received on Mon Oct 05 2009 - 06:10:46 CDT