• It is a phase which identifies a plan for evaluation query that has the least estimated cost.
  • We can use query optimizer when there is lot of algorithms and methods to execute the same task.


  • Query optimizer provides faster output.
  • It takes less time to execute large number of queries.
  • It also reduces time and space complexity.

Categorized in: