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