Part 04 · Query Processing and Optimization
Cardinality Estimation
SelectivityCardinalityIndependence assumption
Guessing how many rows each step returns: selectivity, combining predicates, and why 'city = Dhaka AND country = BD' fools the estimate.
⏱ 6 min · Station 31 of 123