The Optimizer chooses Cost_based approach and optimizes with the goal of b

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

Question Posted / guest

2 Answers
4598 Views
I also Faced
E-Mail Answers

Answer Posted / guest

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

Explain the blob datatype?

1122

Can we call procedure inside function in oracle?

1146

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2081

Explain the use of ignore option in imp command.

1082

What is bulk collect in oracle?

1051

How to retrieve data from an explicit cursor?

1105

What is SQL Tuning Advisor in Oracle?

1245

What are a cluster and non-cluster index?

1064

Explain oracle left join with an example?

1058

What is a subquery in oracle?

1161

What is sharded cluster?

1065

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

1090

Is postgres faster than oracle?

1080

What is an oracle and why it is used?

1209

How can I see all tables in oracle?

1060