Blog Post

SQL Server Support Blog
3 MIN READ

New Trace flags for better maintenance of deleted rows in Columnstore Index

HemanthTarra's avatar
HemanthTarra
Icon for Microsoft rankMicrosoft
Feb 12, 2021
Qualification Limit for REORGANIZE to remove deleted rows from a rowgroup in Columnstore Index: By default when one runs ALTER INDEX REORGANIZE the qualifying limit to remove delete rows from a row...
Published Feb 12, 2021
Version 1.0
MrBarrett's avatar
MrBarrett
Copper Contributor
Jun 15, 2021

Great with more control over this. However, it would be elegant if this behavior could also be controlled with parameters on an ALTER INDEX ... REORGANIZE. Have you considered that?