What is An Optimizer ?
* Generates the optimal execution plan
* Determines the most efficient method for a SQL statement to access requested data
* The optimizer choose the plan with the lowest cost among all considered candidate plans
* The optimizer uses available statistics to calculate cost
* Cost computation accounts for factors of query execution like I/O , CPU, Network, Memory
No comments:
Post a Comment