Nonclustered Index Insert Showplan Operator

The Index Insert operator inserts rows from its input into the nonclustered index specified in the Argument column. The Argument column also contains a SET:() predicate, which indicates the value to which each column is set.

Index Insert is a physical operator.

Nonclustered index insert operator iconGraphical execution plan icon

See Also

Tasks

How to: Display an Actual Execution Plan

Concepts

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

Other Resources

INSERT (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance