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

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)

Other Resources

UPDATE (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance