Advanced Query Optimization in DBMS
Query Optimization is a technique of analyzing and deciding an execution plan that computes the result of the query using less number of resources. The main goal of query optimization is to find an execution plan for that query to reduce the time required to process it.
Two main objectives of Query Optimization are:
- Determine the optimal plan to access the database.
- Reduce the time required to execute the query.
Advanced Query Optimization in DBMS
We will learn about advanced query optimization in DBMS. We will understand about components of optimizer and methods of query optimization. We will also understand about automatic tuning optimizers.