What is a query optimization?

All Questions › Category: Database › What is a query optimization?
0 Vote Up Vote Down
chetan shidling asked 4 years ago

I need short information.

1 Answers
0 Vote Up Vote Down
chetan shidling answered 4 years ago

Query optimization in DBMS is the phase which identifies a plan for evaluation query that has the least estimated cost. This phase comes into the picture when there are a lot of algorithms and methods to execute the same task.
 
The advantages of query optimization are:
 

  1. The output is provided faster.
  2. A larger number of queries can be executed in less time.
  3. Reduces time and space complexity.