patternsqlMinor
How Ola Hallengrens Index maintenance scripts handles columnstore indexes?
Viewed 0 times
hallengrensscriptshandlescolumnstoreindexesmaintenancehowindexola
Problem
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?
My experience is that script didn't do anything to fragmented columnstore index. Is that by design?
Solution
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
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
Context
StackExchange Database Administrators Q#216025, answer score: 5
Revisions (0)
No revisions yet.