The Update operator can also function as a standalone operator when it is executing the Delete task and if no data is required. The Delete Task permits the high-speed deletion of table rows based on a non-index value.
For information on the Delete task option, see Delete Task Option.
The following figure illustrates how the Update operator works.
