What is the effect of setting the value "CHOOSE" for
OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
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 the difference between implicit index and explicit index?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
Can we create database in oracle using command line ?
What is an UTL_FILE.What are different procedures and functions associated with it?
List out the types of joins.
Explain overloading. Can functions be overloaded?
what is a cartition product?
How to connect to the server with user account: sys?
What is an Oracle Instance?
Explain the relationship among Database, Tablespace and Data file?
Find all employees in Dept “Marketing”.
What is tns service name?