sys.column_store_segments

Description

Returns one row for each column segment in a columnstore index. There is one column segment per column per rowgroup. For example, a columnstore index with 10 rowgroups and 34 columns has 340 rows in this view. Indicates the partition ID.

Syntax

<hobt_id, partition_id, column_id, segment_id>