What is the effect of setting the value "CHOOSE" for
OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
- 2 Answers
- 3864 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 |
I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??
Explain the use of compress option in exp command.
How to connect the oracle server as sysdba?
Explain coalesce function?
It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
What is a Redo Log ?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS
What privilege is needed for a user to insert rows to tables in another schema?
How many categories of data types?
What are the set operators union, union all, minus & intersect meant to do?
Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
Oracle General 
