Sign inSign in
ConceptSystems & CS

Cardinality estimation

The process of predicting the number of rows that will be returned by a query operation, such as a filter or join, to help the optimizer choose the most efficient execution plan.
as Andy Pavlo defines itCarnegie Mellon UniversityThe wording closest to all 6 definitions
Watch it explained

Know first

Named as a prerequisite by the lectures that define this. The number is how many say so. A grey one has no page yet.

Query optimization3Query operators2Selectivity2Cost-based optimization1Database catalogs1Logical costs1Query optimizer1Query plan1

Opens up

Concepts that name this one as a prerequisite.

Lecturers

1
  • Andy Pavlo

    Carnegie Mellon University · Graduate

    • 4:37Query Optimizer Implementation 3
    • 10:48Query Cost Models: Statistics
    • 1:21:19Data Formats & Encoding Part 1
    • 4:24Query Cost Models: Cardinality Estimation
    • 20:27SQL Optimization Background

Lectures that assume it

1

Connections

14

The lectures that define it or assume it, and the concepts next to it.

1 lecturer. Definitions are written by AI from each lecture’s transcript. A time with a play mark starts the lecture at the moment the lecturer says it.