MV_COLUMNSTORE_MERGE_STATUS

This view stores information about the status of background_merger processes for columnstore tables.

Column Name

Description

DATABASE_NAME

The name of the related database.

TABLE_NAME

The name of the related table.

PARTITION_ID

The ID of the related partition.

MERGER

Specifies whether the given status is for slow, fast, manual, or index merging.

  • (Current Groups) is the current state of the segment groups regarding the sort key.

  • (Current Index Groups on <index name>) is the current state of the cross segment index blobs (for multi column indexes).

  • (Current Index Groups on Column <column name>) is the current state of the cross segment index blobs (for single column indexes, and columns part of a multi column index).

  • Fast Merger / Slow Merger are the two background merger processes.

  • Manual Merger indicates a user running the OPTIMIZE TABLE command.

STATE

For rows corresponding to the current state of a merge process:

  • Idle - not doing anything.

  • Waiting - waiting on another merger (mainly for manual OPTIMIZE commands).

  • Preparing - gathering information for merge.

  • Merging Segments

  • Compacting Segments

  • Merging Indexes

  • Compacting Indexes

  • Updating Statistics

  • Populating Altering-Encoding

For rows corresponding to the current state of the table (Current Groups, etc.):

  • NULL

  • Building - only for newly added indexes that are not yet populated.

PLAN

The size, in number of segments, or the rows being merged.

PROGRESS_PERCENT

Merge progress represented as a number between 0 and 100.

Last modified: August 29, 2022

Was this article helpful?