MV_COLUMNSTORE_MERGE_STATUS

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.