Export (0) Print
Expand All
Expand Minimize

Clustered Index Delete Showplan Operator

Updated: 17 July 2006

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 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))

Release History

17 July 2006

New content:
  • Added the Examples section.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft