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

How to drop an existing view in oracle?

what is the difference between oracle enterprise edition and oracle express edition?

What is system tablespace?

What is a Data Segment ?

ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?

Explain drop constraint oracle?

How do I call oracle stored procedures that take no parameters?

State the various uses of dbcc command?

what is unique key?

What are the Characteristics of Data Files ?

what are the differen between key flexifild and discriptive fiexifild.

What are the different types of modules in oracle forms?

For more Oracle General Interview Questions Click Here