SQLTeam.com | Weblogs | Forums

SQL 2016 columnstore indexes CCI


#1

I read https://blogs.msdn.microsoft.com/sqlcat/2015/08/17/sql-2016-columnstore-row-group-merge-policy-and-index-maintenance-improvements/

I am confused on when you do the reorganize.

For clustered, non clustered indexes, you normally check the avg fragmentation level > 30 and rebuild or reorganize...etc

What do you check when doing the reorganize for Columnstore clustered indexes