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
- 4505 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 |
How to retrieve data from an explicit cursor?
How to write a query with a left outer join in oracle?
How do you ensure database security?
What is tns name?
What are synonyms used for ?
How do you rate yourself in oracle and sql server ?
How to specify default values in insert statement using oracle?
How to Truncate Table in Oracle
How to delete a column in an existing table in oracle?
Display the records between two range?
What is key preserved table?
How to use select statement to count the number of rows in oracle?
Oracle General 
