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
- 4344 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 |
Is java required for oracle client?
What is a synonym? What are its various types?
how to tune oracle sql queries pls tell me step by step. urgent pls
what is analyze command ? what kind of statistics does it generate?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Can Multiple instances be run on Single Machine???
10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.
how to unbreak sequence numbers during intereptions
How to use subqueries with the exists operator in oracle?
What is an index associated with a constraint?
Explain what are clusters?
What is a trace file and how is it created in oracle?
Oracle General 
