Ask about Clustering Factor to know index either GOOD or BAD
Hi,
I have checked index statistics and read some articles related to clustering factor
So if the value of Clustering Factor near the number of blocks in the table --> the index will be useful.
If Clustering Factor near the number of rows in the table --> the index will be less efficient.
I checked my database and see lot of indexes is less efficient if follow this rule (except the row with yellow highlight is good).
Could you share your experiment about this? If they are BAD, so we should do full table scan instead of using index?
Thanks,