Data Access Question:

Explain What is the function of Optimizer?

Oracle Data Access Interview Question
Oracle Data Access Interview Question

Answer:

The goal of the optimizer is to choose the most efficient way to execute a SQL statement.


Previous QuestionNext Question
Explain What does COMMIT do?Explain What are the different approaches used by Optimizer in choosing an execution plan ?