Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

Clustered Index Delete Showplan Operator

The Clustered Index Delete operator deletes rows from the clustered index specified in the Argument column of the query execution plan. If a WHERE:() predicate is present in the Argument column, then only those rows that satisfy the predicate are deleted.

Clustered Index Delete is a physical operator.

Clustered index delete 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 Delete operator to remove the row.

USE AdventureWorks2008R2;
GO
SET NOCOUNT ON;
GO
SET SHOWPLAN_ALL ON;
GO
DELETE FROM Production.UnitMeasure
WHERE UnitMeasureCode = 'F2';
GO
SET SHOWPLAN_ALL OFF;

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

PhysicalOp

-----------------------------------------------------------------------

Clustered Index Delete

Argument

-----------------------------------------------------------------------

OBJECT:([AdventureWorks2008R2].[Production].[UnitMeasure].[PK_UnitMeasure_UnitMeasureCode]),

OBJECT:([AdventureWorks2008R2].[Production].[UnitMeasure].[AK_UnitMeasure_Name]),

WHERE:([AdventureWorks2008R2].[Production].[UnitMeasure].[UnitMeasureCode]

=CONVERT_IMPLICIT(nvarchar(4000),[@1],0))

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.