The following rule determines whether the
DELETE operation should be executed in parallel:
DELETE operation is parallelized if and only if at least one of the following is true:
The table being updated or deleted has a
PARALLEL hint is specified in the DML statement.
If the statement contains subqueries or updatable views, then they may have their own separate parallel hints or clauses. However, these parallel directives do not affect the decision to parallelize the
The parallel hint or clause on the tables is used by both the query and the
DELETE portions to determine parallelism, the decision to parallelize the
DELETE portion is independent of the query portion, and vice versa.