Clustered Index Update Showplan Operator

The Clustered Index Update operator updates input rows in the clustered index specified in the Argument column.

If a WHERE:() predicate is present, only those rows that satisfy this predicate are updated. If a SET:() predicate is present, each updated column is set to this value. If a DEFINE:() predicate is present, the values that this operator defines are listed. These values may be referenced in the SET clause or elsewhere within this operator and elsewhere within this query.

Clustered Index Update is a logical and physical operator.

Graphical execution plan icon

Examples

The following example deletes a row from a table that has a clustered index. The output of the execution plan shows that the query optimizer uses the Clustered Index Update operator to modify the rows.

USE AdventureWorks;
GO
SET NOCOUNT ON;
GO
SET SHOWPLAN_ALL ON;
GO
UPDATE Sales.SalesPerson
SET Bonus = 6000;
GO
SET SHOWPLAN_ALL OFF;
GO

The execution plan output of the Clustered Index Update operator appears below.

PhysicalOp 
-----------------------------------------------------------------------
Clustered Index Update

Argument
-----------------------------------------------------------------------
OBJECT:([AdventureWorks].[Sales].[SalesPerson].[PK_SalesPerson_SalesPersonID]), 
SET:([AdventureWorks].[Sales].[SalesPerson].[Bonus] = 
    RaiseIfNull(CONVERT_IMPLICIT(money,[@1],0)))

See Also

Tasks

How to: Display an Actual Execution Plan

Concepts

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

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release	History
17 July 2006	New content: Added the Examples section.