What do you understand by Query Optimization ?

  • 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.
Leave a Reply

Your email address will not be published. Required fields are marked *

You May Also Like

What is DBMS Utilities ?

Data Loading Utility: Data loading utility helps to load data from an external format without writing programs. Backup utility: In case of crashes and disasters this utility helps to take…
View Answer