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.
.gif "Clustered index delete operator icon")
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 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))