Update Showplan Operator

The Update operator updates each row from its input in the object specified in the Argument column of the query execution plan. Update is a logical operator. The physical operator is Table Update, Index Update, or Clustered Index Update.

Graphical execution plan icon

See Also

Tasks

How to: Display an Actual Execution Plan

Reference

UPDATE (Transact-SQL)

Table Update Showplan Operator

Nonclustered Index Update Showplan Operator

Clustered Index Update Showplan Operator

Concepts

Logical and Physical Operators Reference

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