In parallel with updating
INSERT statements, however, have their own set of rules. The INSERT operation can be parallelized only if the table being inserted into has a parallel specification or if a PARALLEL hint is included after the INSERT keyword in the statement.
Oracle can parallelize UPDATE and DELETE statements on partitioned tables, but only when multiple partitions are involved. As we discussed in Chapter 3, the degree of parallelism can be specified at the statement level, the object definition level, or the instance level.
As you recall from Chapter 16, the NOT IN anti-join is always serviced by a full-table scan against the outer table, and you have learned that a NOT IN subquery can often be replaced with an outer join and a where bonus IS NULL.First of all is it a one-time query or is it a recurrent query ?