Query Optimization
Query optimization is the process of selecting the most efficient query evaluation plan for a query.
Optimizers use statistical data about relations such as relation sizes and index depths to make a good estimate of cost of a plan.
We will look at cost model, cost of individual operations selection, sorting, join, and other operations.