Which query transformation technique is used by the optimizer?

Examine the Following Query and execution plan:

Which query transformation technique is used by the optimizer?

A.
Filter push down

B.
Subquery factoring

C.
Subquery unnesting

D.
Predicate pushing

Explanation:

Note:
* In the execution plan BX, note the keyword ‘VIEW PUSHED PREDICATE’ indicates that the view
has undergone the join predicate pushdown transformation.