• Article

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.

Clustered index update operator iconGraphical 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)))