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
Give the constructs of a package, function or a procedure.
Is truncate autocommit in oracle?
What is catalog in Oracle?
What are the various oracle database objects?
What are the different types of trigger and explain its various uses and functions?
How to create a single index for multiple columns?
Explain about the analyze command in oracle?
How to get the Installed Oracle Version Information ?
What happens if variable names collide with table/column names?
What is a table index?
How to define a sub function?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
How to set a transaction to be read only in oracle?
How to change program global area (pga) in oracle?
How to view the tablespaces in the current database?