Data Access Question:

Explain What are the factors that affect OPTIMIZER in choosing an Optimization approach?

Oracle Data Access Interview Question
Oracle Data Access Interview Question

Answer:

The OPTIMIZER_MODE initialization parameter Statistics in the Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER SESSION command hints in the statement.


Previous QuestionNext Question
Explain What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command?Explain What are the values that can be specified for OPTIMIZER MODE Parameter?