What are the factors that affect OPTIMIZER in choosing an
Optimization approach ?
Answer Posted / nishi
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
What are the differences between number and binary_float in oracle?
How to execute a stored procedure in oracle?
What is oracle in java?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
List the types of joins used in writing subqueries?
Explain the use of file option in exp command.
How many categories of data types in oracle?
What is the difference between pre-select and pre-query?
What is the exact use of Collections?
What is set operator oracle?
Briefly explain what is literal? Give an example where it can be used?
What is a read only transaction in oracle?
How to find out what oracle odbc drivers are installed?
Explain index?
What is an oracle transaction?