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

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.

Last modified: January 5, 2024

Was this article helpful?