How Oracle Index clustering factor is calculated

What is Oracle index clustering factor(CF)? The clustering factor is a number that represents the degree to which data is randomly distributed in a table as compared to the indexed column. In simple terms, it is the number of “block switches” while reading a table using an index. It is an important statistic that play important …

How Oracle Index clustering factor is calculated Read More »