Clustered Index Delete

The Clustered Index Delete physical operator deletes rows from the clustered index specified in the Argument column. If a WHERE:() predicate is present in the Argument column, then only those rows that satisfy the predicate are deleted.

See Also

Using Clustered Indexes