What is the function of Optimizer ?

The  goal of the optimizer is to choose the most efficient way to execute a SQL statement.
  • Interview Candidate
  • 3
  • 1744

Showing Answers 1 - 3 of 3 Answers

sravan1

  • Dec 11th, 2006
 

The optimizer determines the most efficient way to use the tables and indexes to complete the request made by an SQL statement after considering many factors related to the objects referenced and the conditions specified in the query.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions