Index Rebuild – Does it use the Index or the Table ? (Nothing Touches Me)

Database Management and Performance
| May 14, 2012 22:37 +0000

A common question that gets asked is does Oracle access the index itself or the parent table during an index rebuild to extract the necessary data for the index ? Thought it might be worth a blog post to discuss. Now if the index is currently in an U…

IOT Secondary Indexes – The Logical ROWID Guess Component Part II (Move On)

Database Management and Performance
| May 7, 2012 19:14 +0000

Having mentioned a couple of dangers associated with IOT Secondary Indexes, thought I might discuss a couple of their nicer attributes. In the previous post, we saw how 50-50 index block splits on the ALBUM_SALES_IOT IOT table caused rows to move to…