Answers

Question and Answer:

  Home  Oracle Data Access

⟩ Explain What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command?

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.

 168 views

More Questions for you: