Delete based on rowid
- From: DBA Deepak <oracle.tutorials@xxxxxxxxx>
- To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 5 Oct 2009 16:04:09 +0530
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...
Other related posts: