Export (0) Print
Expand All
Expand Minimize

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 iconGraphical 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 AdventureWorks;
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:([AdventureWorks].[Production].[UnitMeasure].[PK_UnitMeasure_UnitMeasureCode]), 
OBJECT:([AdventureWorks].[Production].[UnitMeasure].[AK_UnitMeasure_Name]), 
WHERE:([AdventureWorks].[Production].[UnitMeasure].[UnitMeasureCode]
    =CONVERT_IMPLICIT(nvarchar(4000),[@1],0))
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft