Alter Index With DATA_COMPRESSION (Page or Row)

olahallengren / sql-server-maintenance-solution

SQL Server Maintenance Solution

https://ola.hallengren.com

MIT License

2.91k stars 756 forks source link

Alter Index With DATA_COMPRESSION (Page or Row) #670

Open alexandreandradeg opened 2 years ago

alexandreandradeg commented 2 years ago

Is it possible to implement a parameter to compress the indexes? tks...

olahallengren commented 2 weeks ago

Thank you for the suggestion. It would be easy to implement. My concern is that setting the compression is typically an operation you only do once for an index, while IndexOptimize is running as a scheduled job.