Delete based on rowid
From: DBA Deepak <oracle.tutorials_at_gmail.com>
Date: Mon, 5 Oct 2009 16:04:09 +0530
Message-ID: <75aa80160910050334p4150fb7fsad7cf7b90e086af9_at_mail.gmail.com>
Have a simple question.
Date: Mon, 5 Oct 2009 16:04:09 +0530
Message-ID: <75aa80160910050334p4150fb7fsad7cf7b90e086af9_at_mail.gmail.com>
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-lReceived on Mon Oct 05 2009 - 05:34:09 CDT