Re: Delete based on rowid

From: <troach_at_gmail.com>
Date: Mon, 5 Oct 2009 11:10:46 +0000
Message-ID: 421104539-1254740942-cardhu_decombobulator_blackberry.rim.net-1625786755-_at_bda026.bisx.prod.on.blackberry>

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

-----Original Message-----

From: DBA Deepak <oracle.tutorials_at_gmail.com> Date: Mon, 5 Oct 2009 16:04:09
To: Oracle-L<oracle-l_at_freelists.org>
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?

Please comment...

--

http://www.freelists.org/webpage/oracle-l Received on Mon Oct 05 2009 - 06:10:46 CDT