Cardinality estimation

The query optimizer's prediction of how many rows each operator will emit, the estimates that determine join order and access paths and the classic source of plan blowups.

grounded in: Trend theme 'Database and query performance craft: practitioners are focused on squeezing correctness and throughput out of SQL data layers.'

Connected concepts

Query planner, Predicate Pushdown, Vectorized query execution