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
- 4453 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 |
Can the query output be sorted by multiple columns in oracle?
can u call user defined functions in select statements
Can a formula column referred to columns in higher group ?
Can we write dml statement in function in oracle?
State some uses of redo log files?
Display Odd/ Even number of records?
which clause we are not used in where clause?
How to connect to a local oracle 10g xe server?
What are Clusters ?
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
wirte the syntax of update query?
Can multiple cursors being opened at the same time?
Oracle General 
