Data Warehousing Question: Download Data Warehousing PDF
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command?
Answer:
The Optimizer chooses Cost based approach and optimizes with the goal of best throughput if statistics for at least one of the tables accessed by the SQL statement exist in the data dictionary. Otherwise the OPTIMIZER chooses RULE based approach.
| Previous Question | Next Question |
| What does a Control file Contain? | What is the function of Optimizer? |