Index Delete
The Index Delete physical operator will delete input rows from the nonclustered index specified in the Argument column. If a WHERE:() predicate is present, only those rows that satisfy this predicate will be deleted.
See Also
DELETE
Using Nonclustered Indexes