What is the effect of setting the 'RULE' for OPTIMIER

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

Question Posted / guest

What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSIO..

Answer / 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

More Oracle General Interview Questions

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

Display the number value in Words?

What is java oracle used for?

what is the difference between substr and instr function in oracle?

what are bitmap indexes? How does they work?

What is autonomous transaction?

What is the difference between column level constraints and table level constraints?

Who developed oracle & when?

How to get the Installed Oracle Version Information ?

How to drop an existing view in oracle?

Explain what are the advantages of views?

For more Oracle General Interview Questions Click Here