What is the effect of setting the value of OPTIMIZER_MODE
to 'RULE' ?
- 1 Answers
- 3687 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4
What are Clusters ?
query to find the maximum no persons with same age(age colomn) from emp table
Oracle
0 Answers ABC, Genpact, HUI, Oracle,
How to convert csv to table in oracle?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What do you mean by merge in oracle?
what is the use of system.effective.date variable in oracle?
How to create DSN..Explain?
2 Answers Accenture, BeBo Technologies, Infosys,
How to check database size in Oracle?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
What are oracle functions?
Oracle General 
