TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Clustered Index Delete Showplan Operator

SQL Server 2008 R2

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

Community Additions

ADD
Show:
© 2016 Microsoft