tigertoolbox icon indicating copy to clipboard operation
tigertoolbox copied to clipboard

Columnstore Reorganize Option

Open vinchackochandy opened this issue 3 years ago • 0 comments

Review the option to include column store reorganize option. It will be a great help for the SQL Server editions below 2019 as from 2019 tuple-mover is helped by a background merge task that automatically compresses smaller open delta rowgroups that have existed for some time as determined by an internal threshold, or merges compressed rowgroups from where a large number of rows has been deleted. Until SQL Server 2017, We need to manually Reorganize a column store index forces delta store row groups into compressed row groups in columnstore, and combine smaller compressed row groups into larger row groups.

vinchackochandy avatar Sep 27 '22 21:09 vinchackochandy