What is the effect of setting the value "CHOOSE" for
OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
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
What is the use of file param in imp command?
How can I see all tables in oracle?
How to select some rows from a table in oracle?
What is a sub query and what are the different types of subqueries?
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?
How to increment dates by 1 in oracle?
Explain what are the characteristics of data files?
What is instant client oracle?
List out the types of joins.
What is transport network substrate (tns) in oracle?
query optmization techniques and quwry analyser+projects+ppts
What is tns name?
What is a synonym? What are its various types?
What is using clause and give example?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.