Search

OakieTags

more tags

Who's online

There are currently 0 users and 38 guests online.

Recent comments

Affiliations

Home

Index Rebuild

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

Submitted by Richard Foote on Tue, 2012-05-15 06:37

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

Rebuilding Indexes and the Clustering Factor Solution (Move On)

Submitted by Richard Foote on Sun, 2011-09-25 08:52

Excellent !! This quiz created quite a bit of debate and it was nice to sit back and read some interesting discussions. The Clustering Factor is basically the measurement of how well aligned the data in the underlining table is in relation to the index and is the number of table related I/Os required to read the entire table via a [...]

Rebuilding Indexes and the Clustering Factor Quiz (One Of The Few)

Submitted by Richard Foote on Tue, 2011-09-20 14:10

Today’s question has been prompted by various recent comments regarding the Clustering Factor (CF) of an index and how to change the CF requires a reorg of the underlining table. It used to be quite a common myth that if the CF of an index was greater that “X” or based on some nonsensical formula the [...]