通过

  • 项目

Clustered Index Delete Showplan 运算符

Clustered Index Delete 运算符从查询执行计划的 Argument 列指定的聚集索引中删除行。如果 Argument 列中存在 WHERE:() 谓词，则仅删除满足该谓词要求的行。

Clustered Index Delete 是一个物理运算符。

Clustered Index Delete 运算符图标图形执行计划图标

示例

下面的示例从表中删除了具有聚集索引的行。执行计划输出表明查询优化器使用 Clustered Index Delete 运算符来删除该行。

USE AdventureWorks2008R2;
GO
SET NOCOUNT ON;
GO
SET SHOWPLAN_ALL ON;
GO
DELETE FROM Production.UnitMeasure
WHERE UnitMeasureCode = 'F2';
GO
SET SHOWPLAN_ALL OFF;

Clustered Index Delete 运算符的执行计划输出显示如下：

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