What is the effect of setting the value "CHOOSE" for
OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
- 2 Answers
- 3436 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What privilege is needed for a user to connect to oracle server?
What do you mean by a database transaction & what all tcl statements are available in oracle?
What is the difference between post-database commit and post-form commit?
Difference between open_form and call_form in oracle.
When do you get a .pll extension in oracle?
Can you drop an index associated with a unique or primary key constraint?
How to convert characters to numbers in oracle?
What is a read write transaction in oracle?
Explain the use of record length option in exp command.
What to do if the binary spfile is wrong for the default instance?
How to drop an index?
How to call a sub procedure?
How to get last row id?
Write a trigger example in oracle?
What is a cursor in oracle?
