Export (0) Print
Expand All
Expand Minimize

Clustered Index Insert Showplan Operator

Updated: 17 July 2006

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.

Clustered index insert operator icon Graphical execution plan icon

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

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