Oracle
1Z0-054 · Question #17
Which three factors influence the optimizer's behavior while choosing an optimization approach and goal for a SQL statement? (Choose three.)
The correct answer is C. object statistics in the data dictionary D. the OPTIMIZER_MODE initialization parameter E. optimizer SQL hints for changing the query optimizer goal. See the full explanation below for the reasoning.
Question
Which three factors influence the optimizer's behavior while choosing an optimization approach and goal for a SQL statement? (Choose three.)
Options
- Aparsing of a SQL statement
- Boperating system (OS) statistics
- Cobject statistics in the data dictionary
- Dthe OPTIMIZER_MODE initialization parameter
- Eoptimizer SQL hints for changing the query optimizer goal
How the community answered
(39 responses)- A15% (6)
- B8% (3)
- C77% (30)
Community Discussion
No community discussion yet for this question.