Blogs about: Index Delete Operations
Featured Blog
Updates and Indexes Part II (Down Is The New Up)
In Updates and Indexes Part I, I described how there’s no such things as an “update” operation as such on a index and that an update is effectively a delete followed by an insert ope… more →
Richard Foote's Oracle Blog
Updates and Indexes Part II (Down Is The New Up)
— 8 comments
wrote 3 years ago: In Updates and Indexes Part I, I described how there’s no such things as an “update … more →
Updates and Indexes Part I (Fashion)
— 27 comments
wrote 3 years ago: Let’s start with a few basic concepts. Simplistically, Oracle doesn’t generally care whe … more →
Empty Leaf Blocks and Statistics (Sense Of Doubt)
— 14 comments
wrote 3 years ago: I’ve recently been discussing how empty index blocks or those blocks that contain nothing but … more →
Deleted Index Entries Part V (Trouble)
— 10 comments
wrote 3 years ago: As discussed in Part IV, index blocks that contain nothing but deleted index entries are placed on t … more →
Deleted Index Entries Part IV (Breaking Glass)
— 5 comments
wrote 3 years ago: Yet another method of cleaning out deleted space Oracle has up its sleeve is the recycling of index … more →
Deleted Index Entries Part II (V-2 Schneider)
— 17 comments
wrote 3 years ago: I’m back !! In Part I, we looked at how index entries are only marked as deleted during delete … more →
Deleted Index Entries - Part I (Let It Be)
— 9 comments
wrote 3 years ago: Just before I hop on a plane to do some training in Europe, thought I might begin a little series on … more →
