Delete based on rowid

From: DBA Deepak <>
Date: Mon, 5 Oct 2009 16:04:09 +0530
Message-ID: <>

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...

Received on Mon Oct 05 2009 - 05:34:09 CDT

Original text of this message