Why BSO Disk Space doesn’t follow Block Density

When choosing which BSO (or Hybrid) dimensions to make dense and which to make sparse, a higher block density is generally considered โ€˜betterโ€™. This is a simplification, as the densest combination isnโ€™t always the best performing, but bear with me. The point I want to make and explain in this post is this:
When using bitmap compression, squeezing a given set of data into a denser arrangement doesnโ€™t always result in a space saving of the same magnitude
This isn’t totally intuitive, and it can come as surprise to see that your huge increase in block density has only made a modest dent in the size of your .pag files.

Continue reading