This value causes the optimizer to the cost-based approach for all SQL sta

What is the effect of setting the value "ALL_ROWS" for
OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

Question Posted / guest

1 Answers
4265 Views
I also Faced
E-Mail Answers

Answer Posted / guest

This value causes the optimizer to the cost-based approach
for all SQL statements in the session regardless of the
presence of
statistics and to optimize with a goal of best throughput.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How many types of table in Oracle?

1055

How to convert characters to dates in oracle?

1021

What happens to indexes if you drop a table?

1107

Difference between cartesian join and cross join?

955

Explain cascading triggers.

1011

What is dynamic proxy?

958

Is oracle a relational database?

870

How to create additional tablespaces for an new database?

968

How to install oracle database 10g xe?

962

How to create a new view in oracle?

1012

How to unlock the sample user account in oracle?

915

What happens if you lost a data file?

976

What is program global area (pga) in oracle?

951

How to delete an existing row from a table in oracle?

1011

Respected sir, Please send me technical questions related to oracle apps..

1758