Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
.gif "Nonclustered index insert operator icon")
Graphical 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)