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
What is instant client oracle?
Explain the use of constraints option in exp command.
What is raw datatype?
How to use "in" parameter properly?
What are the differences between char and varchar2 in oracle?
Explain the use of online redo log files in oracle.
Is there a combination of "like" and "in" in sql?
How a tablespace is related to data files?
How would you begin to troubleshoot an ORA-3113 error?
Can we protect our pl/sql source code?
What is SQL Tuning Advisor in Oracle?
What is a trace file and how is it created in oracle?
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 ?
How to run create database statement again?
How to login to the server without an instance?