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
- 4597 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 |
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
What is meant by raw datatype?
What are main difference between Stored Procedure and Functions.
You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.
How does one get the view definition of fixed views/tables?
How would you change old and new values in an insert, delete and update triggers?
How do I uninstall oracle client from windows?
How to convert a string to a date in oracle database?
How to use subqueries in the from clause in oracle?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
what is the difference between oracle enterprise edition and oracle express edition?
Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?
Oracle General 
