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

which sql command we can use to get a print out from oracle?

primary key is foreign key for the same table?

What is the usage of control file in oracle?

How to download oracle database 10g xe?

How do I connect to oracle?

What is a data dictionary and how can it be created?

A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?

What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)

Differentiate between TRUNCATE and DELETE?

What happens to the indexes if a table is recovered?

find out the second highest salary?

What is the difference between SQL, DDL, and DML?

For more Oracle General Interview Questions Click Here