Home » Oracle » 1z0-117 » 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
Correct Answer: D
Explanation/Reference:
Note:
*In the execution plan BX, note the keyword ‘VIEW PUSHED PREDICATE’ indicates that the view has undergone the join predicate pushdown transformation.
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
