data compression and rebuilding indexes
Can someone enlighten me on this? If i'm doing data compression(page level) does it rebuild indexes too? and how about stats, does it update stats too?
August 31st, 2015 2:41pm

Adding page compression doesn't require an ALTER TABLE statement. It can be done with any command that creates or alters an index.

To answer the question... Adding page compression does require a rebuild of the index which in turn does a full statics update. (There is no need to update statistics separately, after an index rebuild. It would be redundant)

August 31st, 2015 4:38pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics