What is the effect of setting the value of OPTIMIZER_MODE
to 'RULE' ?
- 1 Answers
- 3708 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
How translate command is different from replace?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is a nvl function? How can it be used?
How to put more than 1000 values into an oracle in clause?
What is the data pump export utility?
Difference between hot backup vs. Cold backup?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What is concurrency in oracle?
How to manage transaction isolation level?
what is reindexing?
What is meant by recursive hints in oracle?
How to download oracle database 10g xe?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
How to use "if" statements on multiple conditions?
what are the advantages of running a database in archive log mode?
