SQL Server – Ola Hallengren’s Index Maintenance Scripts for Columnstore Indexes

columnstoreola-hallengrensql server

I'd like to know how Ola's script handles columnstore indexes. Couln't find any information about that, only in the version history it was mentioned that script does have a support.

My experience is that script didn't do anything to fragmented columnstore index. Is that by design?

Best Answer

Ola Hallengren's solution doesn't support Columnstore indexes for now.

There is an outstanding feature request on his Github that hasn't been closed as wontfix so you might want to keep an eye on that: ColumnStore Support for Index Maintenance #71