MV_COLUMNSTORE_FILES

This view stores information about columnstore files.

Column Name	Description
`DATABASE_NAME`	The name of the related database.
`TABLE_NAME`	The name of the related table.
`FILE_TYPE`	The type of a given columnstore file. Possible values include: `AUTOSTATS` - stats for the optimizer `FULLTEXT` - full-text index `INVERTED_INDEX` - secondary hash index `COLUMN` - data for columns, may be encoded `COLUMN_GROUP` - indicates the column group index blobs Both COLUMN and INVERTED_INDEX objects can be stored inside one columnstore file. In these cases, `FILE_TYPE` shows the type of the first object in that file. To get detailed information for all columns and indexes in each file, use `MV_COLUMNAR_SEGMENT_INDEX`.
`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.
`SIZE`	The size, in bytes, of a given columnstore file.
`CREATION_TIME`	The timestamp when a given columnstore file 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.

Was this article helpful?