Interested to Buy Any Domain ? << Click Here >> for more details...
What is the effect of setting the value "CHOOSE" for
OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
- 2 Answers
- 4338 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
How to create a table interactively?
Explain the use of record length option in exp command.
How to display employee records who gets more salary than the average salary in the department?
Explain integrity constraints?
How do I spool in oracle?
What are the differences between interval year to month and interval day to second?
How to recover a dropped table in oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What is the difference between $oracle_base and $oracle_home?
What is a static data dictionary in oracle?
Explain rename?
Is it possible to split the print reviewer into more than one region ?
How to insert multiple rows with one insert statement in oracle?
Explain the difference between sql and oracle?
