Oracle
1Z0-063 · Question #139
Which three factors influences the optimizer's choice of an execution plan?
The correct answer is A. Cardinality estimates D. Type of connection used to connect to database instance E. Object statistics in the data dictionary. See the full explanation below for the reasoning.
Question
Which three factors influences the optimizer's choice of an execution plan?
Options
- ACardinality estimates
- BThe OPTIMIZER_MODE initialization parameter
- CFixed baselines
- DType of connection used to connect to database instance
- EObject statistics in the data dictionary
How the community answered
(57 responses)- A82% (47)
- B11% (6)
- C7% (4)
Community Discussion
No community discussion yet for this question.