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.

Clustered index insert operator iconGraphical 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())

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.