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.

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

See Also

Tasks

How to: Display an Actual Execution Plan

Concepts

Logical and Physical Operators Reference
Clustered Index Structures
Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release	History
17 July 2006	New content: Added the Examples section.