tigertoolbox
tigertoolbox copied to clipboard
Columnstore Reorganize Option
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.