Insert Showplan Operator

The Insert logical operator inserts each row from its input into the object specified in the Argument column. The physical operator is either the Table Insert, Index Insert, or Clustered Index Insert operator.

Insert (Database Engine) operator iconGraphical execution plan icon

See Also

Tasks

How to: Display an Actual Execution Plan

Reference

Clustered Index Insert Showplan Operator
Table Insert Showplan Operator
Nonclustered Index Insert Showplan Operator

Concepts

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

Other Resources

INSERT (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance