What is the effect of setting the value of OPTIMIZER_MODE
to 'RULE' ?
Answer Posted / guest
This value causes the optimizer to choose the rule_based
approach for all SQL statements issued to the instance
regardless of the presence of statistics.
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
What are the execution control statements in oracle?
What privilege is needed for a user to create indexes in oracle?
What do you mean by a tablespace?
What happens if variable names collide with table/column names?
How to call a sub procedure?
What is recovery manager(rman) backup in Oracle?
Explain the use of inctype option in exp command.
What is Trigger in Oracle?
How to set up autotrace for a user account?
How to resolve name conflicts between variables and columns?
How a tablespace is related to data files?
Is rowid unique in oracle?
Explain about the analyze command in oracle?
How to write a query with a right outer join in oracle?