This value causes the optimizer to choose the rule

What is the effect of setting the value of OPTIMIZER_MODE
to 'RULE' ?

Question Posted / guest

1 Answers
4092 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

Please Help Members By Posting Answers For Below Questions

What is a initialization parameter file in oracle?

1018

How to define an external table with a text file?

1045

What is a user role in oracle?

1100

Explain a segment?

1071

How to get last row id?

970

What is primefaces used for?

1035

Explain the use of control file?

1094

What are the differences between primary key and unique key?

989

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1882

Explain the use of Merge statement in oracle 11g

1010

How to define a data field as not null?

1091

How does the on-delete-cascade statement work?

1085

What is object data modeling?

934

Is there any function in oracle similar like group_concat of mysql?

1035

candidate key is subset of super key but not vice-verse explain

2056