What is the effect of setting the value "CHOOSE" for
OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
- 2 Answers
- 3443 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
Why use resource manager in Oracle?
What is the recommended interval at which to run statspack snapshots, and why?
Is the After report trigger fired if the report execution fails ?
Explain about achiever in sql?
11. Display the client number and name and the client number and name of the person who referred that client.
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
Can group functions be used in the order by clause in oracle?
How to retrieve the count of updated rows?
How to best split csv strings in oracle 9i?
What is SQL access advisor in Oracle?
How to convert characters to times in oracle?
what is insert all statement in sql
What is hash cluster in oracle?
How can I introduce multiple conditions in like operator?
Why should I use oracle database?
