Table Insert Showplan Operator

  • Article

The Table Insert operator inserts rows from its input into the table specified in the Argument column of the query execution plan. The Argument column also contains a SET:() predicate, which indicates the value to which each column is set. If Table Insert has no children for insert values, then the row inserted is taken from the Insert operator itself.

Table Insert is a physical operator.

Table insert operator iconGraphical execution plan icon

See Also

Tasks

How to: Display an Actual Execution Plan

Reference

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