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.
| DELETE | Using Nonclustered Indexes |