Data Access Question: Download Questions PDF
Explain What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command?
![Oracle Data Access Interview Answer Oracle Data Access Interview Question](https://globalguideline.com/public/images/interview/33.png)
Answer:
The Optimizer chooses Cost_based approach and optimizes with the goal of best throughput if statistics for atleast one of the tables accessed by the SQL statement exist in the data dictionary. Otherwise the OPTIMIZER chooses RULE_based approach.
Download Oracle Data Access Interview Questions And Answers
PDF
Previous Question | Next Question |
Explain What is SAVE POINT? | What is RULE-based approach to optimization? |