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

IS it possible to built the oracle database without setting the kernal parameters?

2393

How to create a new table by selecting rows from another table?

1147

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1950

What is a package ? What are the advantages of package ?

1136

Explain table?

1174

What privilege is needed for a user to create views in oracle?

1091

How to invoke the data pump export utility?

1251

6. Display the client name and order date for all orders using the traditional method.

2353

What are the different windows events activated at runtime ?

2941

How to fetch the row which has the max value for a column?

1042

What are the differences between number and binary_float in oracle?

1147

What are a query and state the different types of queries and their uses?

1062

What is ADDM Advisor in Oracle?

1219

What are privileges and grants?

1103

How to load a large xml file?

1105