sys.column_store_row_groups

Description

Provides columnstore index information on a per-segment basis. For clustered columnstore indexes, number of rows physically stored (including those marked as deleted) and a column for the number of rows marked as deleted. Use groups have a high percentage of deleted rows and should be rebuilt. The ID of the table on which this index is defined. The ID of the columnstore index.

Syntax

sys.column_store_row_groups