Split Showplan Operator

The Split operator is used to optimize update processing. It splits each update operation into a delete and an insert operation.

Split is a logical and physical operator.

Graphical execution plan icon

See Also

Tasks

How to: Display an Actual Execution Plan

Reference

Collapse Showplan Operator

UPDATE (Transact-SQL)

Concepts

Logical and Physical Operators Reference

Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)