Export (0) Print
Expand All
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

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 icon Graphical execution plan icon

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 AdventureWorks2008R2;
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:([AdventureWorks2008R2].[Sales].[SalesPerson].[PK_SalesPerson_BusinessEntityID]),

SET:([AdventureWorks2008R2].[Sales].[SalesPerson].[Bonus] =

RaiseIfNull(CONVERT_IMPLICIT(money,[@1],0)))

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.