Examine the Following Query and execution plan: Which query transformation technique is used by the optimizer?

The correct answer is D. Predicate pushing. In the execution plan BX, note the keyword 'VIEW PUSHED PREDICATE' indicates that the view has undergone the join predicate pushdown transformation.

Understanding and Influencing the Optimizer

Question

Examine the Following Query and execution plan:

Which query transformation technique is used by the optimizer?

Exhibit

Options

AFilter push down
BSubquery factoring
CSubquery unnesting
DPredicate pushing

How the community answered

(16 responses)

A
6% (1)
B
13% (2)
C
6% (1)
D
75% (12)

Explanation

In the execution plan BX, note the keyword 'VIEW PUSHED PREDICATE' indicates that the view has undergone the join predicate pushdown transformation.

Topics

#query transformation#predicate pushing#optimizer rewrites#subquery unnesting

Community Discussion

No community discussion yet for this question.

Full 1Z0-117 Practice