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
Difference between pre-select and pre-query
Explain the difference between sap and oracle?
Why we use bulk collect in oracle?
What is backup in Oracle?
What do you mean by group by clause?
Can a formula column be obtained through a select statement ?
What is the difference between a user and a schema in oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What do you mean by cdb and pdb in oracle 12c?
What is proxy method?
What is BBED in Oracle?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How does Oracle guarantee data integrity of data changes?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
How to use "startup" command to start default instance?