view counter

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

Thanks to Richard Foote for this story

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 UNUSABLE state, then Oracle clearly can’t use the existing [...]

view counter

Read the entire article at its source

view counter