index leaf block dump
-
While preparing the series of posts about Clustering Factor (aka CLUF in 10053 traces) I came across an interesting caveat which I decided to explore.I will make an attempt to explain its matter, although I encourage you to reach out to the part3 of the mentioned series and navigate to “Quantifying physical reads for low CLUF” and…
-
This post is the continuation of the previous part. Clustering Factor – tests with block dumps My test environment comprises a table with 10 million rows and three columns with two indexes:– ID_SORTED (unique, generated as sorted) with the index on it– ID_MESS (almost unique, generated as scattered) with the index on it– PAD (filler…