Tuesday, August 14, 2012

How does oracle calculate the clustering factor ?

  • Performs a full index scan (or estimate thereof)
  • Examines each rowid value to determine if specific block referenced is the same block as the previous rowid
  • If it differs, the clustering factor is incremented by 1
  • At the end of the scan, the final tally becomes the clustering factor of the index

No comments:

Post a Comment