• 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.

Advantages

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