The Optimizer chooses Cost_based approach and optimizes with the goal of

What is the effect of setting the value "CHOOSE" for
OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

Question Posted / nishi

2 Answers
4454 Views
I also Faced
E-Mail Answers

Answer Posted / nishi

The Optimizer chooses Cost_based approach and optimizes with the goal of best throughput if statistics for atleast one of the tables accessed by the SQL statement exist in the data dictionary. Otherwise the OPTIMIZER chooses RULE_based approach.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to invoke the data pump import utility?

1143

Does oracle charge for java?

1043

How to convert a string to a date in oracle database?

1031

What is difference between sid and service name in oracle?

944

Explain what are the advantages of views?

1050

Explain enable novalidate constraint.

1064

What are the various types of snapshots ?

1011

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2119

What is the oracle implicit cursor?

1035

What is backup in Oracle?

983

Oracle

2355

What are data pump export and import modes?

1048

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2045

How to create a new table in oracle?

1134

How to create a stored function in oracle?

1093