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.
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.