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 use an oracle sequence generator in a mapping?

What is an Extent ?

Can the query output be sorted by multiple columns in oracle?

Can we store pictures in the database and if so, how it can be done?

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

How to use "if" statements on multiple conditions?

Write a simple Store procedure and pass parameter to it ?

How to use "startup" command to start default instance?

what is the difference between table and veiw?

Explain what are the type of synonyms?

How to calculate date and time differences in oracle?

What is Redo Log Buffer in Oracle?

For more Oracle General Interview Questions Click Here