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

When do I need to use a semicolon vs a slash in oracle sql?

1090

Why do we need oracle client?

949

How to create tables for odbc connection testing?

1117

How to turn on or off recycle bin for the instance?

1085

What privilege is needed for a user to delete rows from tables in another schema?

1070

Query to retrieve record for a many to many relationship ?

2520

what is the scripts in data base?

2154

What is parameterized cursor in oracle?

1150

how may join possible between (requisition with purchase order)

2252

What is save point in oracle database?

1296

Explain oracle left join with an example?

1013

What is system tablespace?

1098

What is an oracle function?

1165

Can the query output be sorted by multiple columns in oracle?

992

What is the difference between postgresql and oracle?

1048