clustering factor

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