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