Data Access Question: Download Questions PDF
Explain What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command?
Answer:
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.
Download Oracle Data Access Interview Questions And Answers
PDF
Previous Question | Next Question |
Explain Can we delete tuples in a table based on date column? And how? | Explain What is Read-Only Transaction? |