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
- 4390 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 drop a stored procedure in oracle?
Explain temporal data types in oracle
what is the difference between substr and instr function in oracle?
How to update a table row with a record?
How to write a query with an inner join in oracle?
What is oracle analytical function?
What is a trace file and how is it created in oracle?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
Explain the use of indexes option in exp command.
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How to list all user accounts in oracle?
What is the difference between PFILE and SPFILE in Oracle?
How to use "startup" command to start default instance?
How can windows applications connect to oracle servers?
What do you mean by group by clause?
