Nonclustered Index Update Showplan Operator

The Nonclustered Index Update physical operator updates rows from its input in the nonclustered index specified in the Argument column. If a SET:() predicate is present, each updated column is set to this value. Nonclustered Index Update is a physical operator.

Nonclustered index update operator iconGraphical execution plan icon

See Also

Tasks

How to: Display an Actual Execution Plan

Concepts

Logical and Physical Operators Reference
Creating Nonclustered Indexes
Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)

Other Resources

UPDATE (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance