What is the effect of setting the value "CHOOSE" for
OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
- 2 Answers
- 3407 Views
- I also Faced
- E-Mail Answers
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 |
How to do paging with oracle?
What is the difference between substr and instr?
How to drop an existing view in oracle?
What is a trigger and what are its types?
Define 'view' advantage ?
what is candidate key & super key
Why does for update in oracle 8 cause an ora-01002 error?
Explain database link?
Explain compound trigger in oracle?
Is rowid unique in oracle?
How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
Oracle General 
