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
- 4455 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to use "startup" command to start default instance?
What is the data type of dual table?
What is blob datatype?
What is difference between truncate and delete?
How to use "in" parameter properly?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Explain self joins in oracle?
Explain what are the type of synonyms?
Explain the use of grant option in exp command.
What is literal?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
How to define an anonymous procedure without variables?
What is integrity and what is constraint??Explain with example
What are privileges and grants?
Explain drop constraint oracle?
