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


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 rowgroup is –> the specific rowgroup have 10% of the max possible rows in a rowgroup deleted.


As the max possible rows in a row group is 1M rows, the qualification limit is that we need to have 100K rows deleted in a row group for the Reorganize to remove them from the Rowgroup.


From <>


This threshold limit has few concerns


for few