Warning: Trying to access array offset on false in /home3/indiakep/public_html/wp-content/plugins/dw-question-answer/inc/Template.php on line 8
1 Answers
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:
- The output is provided faster.
- A larger number of queries can be executed in less time.
- Reduces time and space complexity.