- 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