add compression as parameter

[sqldbamo]

Hi, thank you for the great script. would it be a good idea to add compression as a parameter, if index is not compressed , that parameter can be set to Y if you would like to compress it, if index is part of the rebuild.

[erikdarlingdata]

I would love this. When I work with clients, implemented Page compression is often a big win, but sort of tedious to roll out and then to make sure all new indexes have it in place.

It's currently implemented in Microsoft's Adaptive Index Defrag procedure, but I can't find anyone using it in the wild to make it useful, and getting people to switch to do one thing is kind of silly.

Thanks!