clustering factor

What is Oracle index clustering factor(CF)? The clustering factor is a number which represent 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 statistics which play important […]