Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Columnstore Reorganize Option #282

Open
vinchackochandy opened this issue Sep 27, 2022 · 0 comments
Open

Columnstore Reorganize Option #282

vinchackochandy opened this issue Sep 27, 2022 · 0 comments

Comments

@vinchackochandy
Copy link

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant