Data Access Question:

Download Job Interview Questions and Answers PDF

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.

Download Oracle Data Access Interview Questions And Answers PDF

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