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.

Update (Database Engine) operator iconGraphical execution plan icon

See Also


How to: Display an Actual Execution Plan


Table Update Showplan Operator
Nonclustered Index Update Showplan Operator
Clustered Index Update Showplan Operator


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