What is the effect of setting the 'RULE' for OPTIMIER_GOAL
parameter of the ALTER SESSION Command ?

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



Post New Answer       View All Answers


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