sys.column_store_index_stats (Transact-SQL)
[This documentation is for preview only, and is subject to change in later releases. Blank topics are included as placeholders.]
Contains a row for each columnstore index.
|
Column name |
Data type |
Description |
|---|---|---|
|
name |
sysname |
Name of the columnstore index. |
|
object_id |
int |
ID of the table that has this columnstore index |
|
index_id |
int |
ID of the columnstore index. Same as the index_id in sys.indexes. |
|
type_desc |
nvarchar(60) |
Description of the index type. Possible values are CLUSTERED COLUMNSTORE or NONCLUSTERED COLUMNSTORE. 
Note
Columnstore indexes cannot be clustered indexes. This value exists for potential future implementation.
|
|
number_of_segments |
bigint |
Number of segments in the columnstore index. |
Requires VIEW DEFINITION permission on the table.
The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.
