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

What is rowid and rownum in oracle?

24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.

what are archived logs?

How do I find my oracle client driver version?

How to count groups returned with the group by clause in oracle?

How to assign values to data fields in record variables?

what is the syntax of DROP command?

How to omit columns with default values in insert statement in oracle?

How to work with data objects interactively?

What is flashback Query ? And Use ?

Does oracle charge for java?

How to define a data source name (dsn) in odbc manager?

For more Oracle General Interview Questions Click Here