adspace


  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

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

Question Posted / guest

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

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1956

How to start an oracle instance?

1103

Design database draw er diagram for a certain scenario ?

4656

What is oracle latest version?

1174

How to write a left outer join with the where clause in oracle?

1155

How to select all columns of all rows from a table in oracle?

1132

How to use values from other tables in update statements using oracle?

1158

How to put more than 1000 values into an oracle in clause?

1115