What is the effect of setting the value "CHOOSE" for
OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
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 is a database table in oracle?
What are the attributes that are found in a cursor?
Explain the use of owner option in exp command.
How to write a query with a left outer join in oracle?
What is the Tune Query
How many types of auditing in Oracle?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What is the maximum limit on the number of columns in a table?
what is a Nested Loop join?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
What is the difference between pre-select and pre-query?
What are the attributes of cursor?
How to create a table interactively?
What is the relation of a user account and a schema?
WHAT IS ecc 6.0