ColumnStore Support for Index Maintenance

[GO-DFisk]

Please add full support for maintenance / optimization of column Store Indexes.

[thornersetrans]

Good feature to have, more usage of this SQL Server feature as time goes on.

[Alan-Harris]

Ola - Any ETA on when this functionality will be included? This is very much needed, as these indexes need the reorganization process to include a command that will move all noncompressed rowgroups into compression.

-- This command will force all CLOSED and OPEN rowgroups into the columnstore.
ALTER INDEX idx_cci_target ON cci_target
REORGANIZE WITH (COMPRESS_ALL_ROW_GROUPS = ON);

[mdgreen99]

I added rudimentary support for the COMPRESS_ALL_ROW_GROUPS option for columnstore index reorgs to the 2019-01-13 13:51:41 version, via a @CompressAllRowGroups parameter, for whatever it's worth.

IndexOptimize_with_CCI.diff.txt

[m60freeman]

SentryOne's optimizations for large implementations uses Clustered Columnstore Indexes in their repository and requires "index maintenance, stats update scripts, and defrags should be disabled for all CCI'd and memory optimized staging tables". Do I need to use any specific parameters in the Maintenance Solution jobs to implement that, or does the Solution currently ignore those?

[mahu-y]

Do i have to use any special parameter to include non clustered columnstoreindex to rebuild ?

[hbentaleb]

Ola, Any ETA on that feature? Thx!

[martintints]

Pretty please implement this :)

[scatmull]

We are starting heavy investment into columnstore. Having some well used and adopted maintenance options here would be very helpful.

[earthcoder]

I added rudimentary support for the COMPRESS_ALL_ROW_GROUPS option for columnstore index reorgs to the 2019-01-13 13:51:41 version, via a @CompressAllRowGroups parameter, for whatever it's worth.

IndexOptimize_with_CCI.diff.txt

i tried this seems to work ok, anyone else have issues with this?