What is the effect of setting the value "CHOOSE" for
OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
Answers were Sorted based on User's Feedback
Answer / guest
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.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nishi
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.
Is This Answer Correct ? | 0 Yes | 0 No |
What is COST-based approach to optimization ?
How to get a list of all background sessions in the database?
What are the four Oracle system processes that must always be up and running for the database to be useable?
How do we get field detail of a table?
How do I connect to oracle?
In Oracle 10g, "g" Stands for what?
What is a public synonym?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
Explain what are the advantages of views?
How to view the dropped tables in your recycle bin?
How will you identify oracle database software release?