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
- 4345 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What do you mean by a tablespace?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
Can we save images in a database and if yes, how?
How to pass parameters to procedures in oracle?
How to create a new table by selecting rows from another table?
How to get last row id?
What are ddl statements in oracle?
 What are the oracle DML commands possible through an update strategy?
How do I spool in oracle?
How to open a cursor variable?
How to download oracle database 10g xe?
What is oracle database client?
Differentiate between pre-select and pre-query?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
How to assign values to variables?
