Skip to main content
deleted 162 characters in body
Source Link
Hannah Vernon
  • 70.5k
  • 22
  • 177
  • 321

Either way, page compression is going to shuffle data around a LOT. I would estimate doing the compression first would result in less overall I/O since the clustering operation will be reading compressed pages.

I would not be surprised if some of the guys at http://dba.stackexchange.com might have far more to say about it!

Either way, page compression is going to shuffle data around a LOT. I would estimate doing the compression first would result in less overall I/O since the clustering operation will be reading compressed pages.

I would not be surprised if some of the guys at http://dba.stackexchange.com might have far more to say about it!

Either way, page compression is going to shuffle data around a LOT. I would estimate doing the compression first would result in less overall I/O since the clustering operation will be reading compressed pages.

Post Migrated Here from stackoverflow.com (revisions)
Source Link
Hannah Vernon
  • 70.5k
  • 22
  • 177
  • 321

Either way, page compression is going to shuffle data around a LOT. I would estimate doing the compression first would result in less overall I/O since the clustering operation will be reading compressed pages.

I would not be surprised if some of the guys at http://dba.stackexchange.com might have far more to say about it!