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

What is instant client oracle?

829

Explain the use of constraints option in exp command.

810

What is raw datatype?

868

How to use "in" parameter properly?

841

What are the differences between char and varchar2 in oracle?

838

Explain the use of online redo log files in oracle.

806

Is there a combination of "like" and "in" in sql?

838

How a tablespace is related to data files?

845

How would you begin to troubleshoot an ORA-3113 error?

1869

Can we protect our pl/sql source code?

818

What is SQL Tuning Advisor in Oracle?

900

What is a trace file and how is it created in oracle?

785

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2072

How to run create database statement again?

844

How to login to the server without an instance?

855