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
- 4513 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 |
What is currency type in database ?
Explain rename?
What is self-referential integrity constraint ?
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
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?
Explain about functional dependency and its relation with table design?
What privilege is needed for a user to create tables in oracle?
without using count(*) and rownum how can we count total record in a table
What is recycle bin in Oracle?
How to create DSN..Explain?
2 Answers Accenture, BeBo Technologies, Infosys,
What is the purpose of a cluster?
What is recovery manager in Oracle?
Oracle General 
