This value causes the optimizer to choose the rule-based approach for all

What is the effect of setting the 'RULE' for OPTIMIER_GOAL
parameter of the ALTER SESSION Command ?

Question Posted / guest

Answer Posted / guest

This value causes the optimizer to choose the rule-based
approach for all SQL statements in a session regardless of
the presence of statistics

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

State and explain the different types of data models?

935

What is a parameter file in oracle?

1122

What is where clause in oracle?

1022

How to drop an index in oracle?

1060

Does oracle partitioning improve performance?

986

How to store only time; not date and time?

1015

How to generate query output in html format?

1106

How can I see all tables in oracle?

1005

How to get the Installed Oracle Version Information ?

1117

How to lock and unlock a user account in oracle?

1096

Which is better Oracle or MS SQL? Why?

6370

What are the execution control statements?

1061

How oracle handles dead locks?

1064

Why do we use bulk collect in oracle?

1056

Explain the use of owner option in exp command.

1039