1

If the Ola Hallengren index maintenance solution is installed onto a server which already has compression applied to several of the indexes, will the script respect the current compression level when rebuilding the corresponding index?

Improve this question

1 Answer 1

Reset to default
6

Yes - I don't see how Ola's script could possibly alter the existing compression level of an index.

If you look at the source for Ola's Index Maintenance, you will not see the word COMPRESSION anywhere. In order to alter the compression level, his script would actually have to have the word COMPRESSION in it.

Improve this answer
2
  • But on alter with rebuild (which happens past a certain fragmentation threshold), unless you specify that you want to rebuild indexes with data compression, wouldn't that mean that the rebuild will create new uncompressed indexes?
    – Paul-Sebastian Manole
    Jan 9, 2019 at 12:57
  • 1
    @Paul-SebastianManole - no, unless you specify a compression level, the existing compression level remains - you can easily verify this by running a test.
    – Scott Hodgin - Retired
    Jan 9, 2019 at 13:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.