Data Access Question: Download Questions PDF
Explain What are the factors that affect OPTIMIZER in choosing an Optimization approach?
Answer:
The OPTIMIZER_MODE initialization parameter Statistics in the Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER SESSION command hints in the statement.
Download Oracle Data Access Interview Questions And Answers
PDF