Automatic Tuning Optimizers
Optimizers perform different actions based upon how they are invoked.
This includes following two types:
- Normal Optimization: In Normal Optimization, optimizer parses the query and produces an execution plan within a specific time limits.
- SQL Tuning Advisor Optimization: In this, optimizer perform additional analysis to further produce more efficient plan. The output of the optimizer is a series of action along with their expected benefits to improve the plan.
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.