Clustered Index Insert Showplan Operator
The Clustered Index Insert Showplan operator inserts rows from its input into the clustered index specified in the Argument column. The Argument column also contains a SET:() predicate, which indicates the value to which each column is set. If Clustered Index Insert has no children for insert values, the row inserted is taken from the Insert operator itself.
Clustered Index Insert is a physical operator.
.gif "Clustered index insert operator icon")
Graphical execution plan icon
Examples
The following example inserts a row into a table that has a clustered index. The output of the execution plan shows that the query optimizer uses the Clustered Index Insert operator to insert the row.
USE AdventureWorks;
GO
SET NOCOUNT ON;
GO
SET SHOWPLAN_ALL ON;
GO
INSERT INTO Production.UnitMeasure
VALUES (N'F2', N'Square Feet', GETDATE());
GO
The execution plan output of the Clustered Index Insert operator appears below.
PhysicalOp
-----------------------------------------------------------------------
Clustered Index Insert
Argument
-----------------------------------------------------------------------
OBJECT:([AdventureWorks].[Production].[UnitMeasure].[PK_UnitMeasure_UnitMeasureCode]),
OBJECT:([AdventureWorks].[Production].[UnitMeasure].[AK_UnitMeasure_Name]),
SET:([AdventureWorks].[Production].[UnitMeasure].[UnitMeasureCode] =
RaiseIfNull([Expr1003]),[AdventureWorks].[Production].[UnitMeasure].[Name] =
RaiseIfNull([Expr1004]),[AdventureWorks].[Production].[UnitMeasure].[ModifiedDate] = RaiseIfNull(getdate())),
DEFINE:([Expr1003]=CONVERT_IMPLICIT(nchar(3),[@1],0),
[Expr1004]=CONVERT_IMPLICIT(nvarchar(50),[@2],0), [ConstExpr1006]=getdate())