What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
- 0 Answers
- 608 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.
What is different bet native dynamic sql and Dbms_Sql?
How to start instance with a minimal initialization parameter file?
Difference between an implicit & an explicit cursor.?
Define oracle database
What is the difference between column level constraints and table level constraints?
14 Answers IBM, TCS,
Explain the use of show option in imp command.
what is primary key and foreign key when and where have to use
what is a view?
What is difference between SUBSTR and INSTR?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How many memory layers are in the shared pool?
Oracle General 
