6.830/6.814 Lecture 10: Query Optimization
Pedro Cattori · 71:04
This MIT database lecture explains cost-based query optimization from the Selinger (System R, 1979) paper. To pick the cheapest plan, the optimizer needs selectivity estimates from table statistics, page-I/O-plus-CPU...