MV_COLUMNAR_SEGMENT_INDEX

This view stores information about indexes used to sort columnstore segments.

Column Name	Description
`DATABASE_NAME`	The name of the related database.
`TABLE_NAME`	The name of the related table.
`INDEX_NAME`	The name of a given columnstore segment’s index.
`SEGMENT_ID`	The `ID` of a given columnstore segment.
`FILE`	The name of a given columnstore file.
`HOST`	The hostname or IP address for the related leaf node.
`PORT`	The port number of the related leaf node.
`NODE_ID`	The `ID` of the related leaf node.
`PARTITION`	The `ID` of the related partition.
`ENCODING`	The type of encoding for a given column.
`UNCOMPRESSED_SIZE`	The size, in bytes, of the column.
`COMPRESSED_SIZE`	The size, in bytes, of a given segment index. The "uncompressed size" of the index is the size of the data in the indexed column. Since the index stores extra indexing structures it is possible for the index size to be larger than the data in the indexed column.
`CREATION_TIME`	The timestamp when a given columnstore segment was created.
`LSN`	Log sequence number of the related blob file.
`TERM`	The term of the database, used to uniquely identify which node was the master of a specific database.
`CHECKSUM`	The `crc32c` checksum of the file contents.
`FILE_OFFSET`	Specifies the offset in the file where a given segment is stored.

Was this article helpful?