Interested to Buy Any Domain ? << Click Here >> for more details...
What is the effect of setting the value of OPTIMIZER_MODE
to 'RULE' ?
- 1 Answers
- 4026 Views
- I also Faced
- E-Mail Answers
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 object data modeling?
What is the maximum limit on the number of columns in a table?
Describe an oracle table?
How to use existing values in update statements using oracle?
what are actual and formal parameters?
Is java required for oracle client?
What is private procedure oracle?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
How to define a record variable to store a table row?
how to make an oracle object
Explain an integrity constrains?
Why we use bulk collect in oracle?
What is Segment Advisor in Oracle?
How to rebuild an index in oracle?
What is the difference between $oracle_base and $oracle_home?
