What is the effect of setting the value "CHOOSE" for
OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
- 2 Answers
- 3422 Views
- I also Faced
- E-Mail Answers
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
Which environment variables are absolutely critical in order to run the OUI?
How can we find out the current date and time in oracle?
Write a syntax for update query in oracle?
What is a server parameter file in oracle?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
master table and child table performances and comparisons in Oracle ?
What is the fastest query method to fetch data from the table?
What are the components of logical database structure in oracle database?
How to estimate disk space needed for an export job?
What is the data type of dual table?
How a database is related to tablespaces?
Explain what are the different type of segments?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
How data locks are respected in oracle?
how to join query for one source type is oracle another source type is sql server ?
