Table Merge Showplan Operator

The Table Merge operator applies a merge data stream to a heap. The operator deletes, updates, or inserts rows in the table specified in the Argument column of the operator. The actual operation performed depends on the run-time value of the ACTION column specified in the Argument column of the operator.

Table Merge is a physical operator.

Table merge operatorGraphical execution plan icon