Sign inSign in
ConceptSystems & CS

Query optimizer

A component of a database system that transforms a logical query plan into a more efficient physical execution plan using rules or cost estimation.
as Jignesh Patel defines itCarnegie Mellon UniversityThe wording closest to all 4 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.

Relational algebra3Cost estimation1Cost-based optimization1Query execution1Query execution plans1Query optimization1SQL queries1Transformation rules1

Opens up

Concepts that name this one as a prerequisite.

Lecturers

2

Each in their own terms, from the easiest level.

  • Andy Pavlo

    Carnegie Mellon University · Undergraduate

    The component of a DBMS that finds a correct physical execution plan for a given query with the lowest cost.
    • 1:09:30Distributed Data Warehouse OLAP Databases
    • 2:56Query Optimizer Implementation 1
    • 1:17:28Yellowbrick Data Warehouse System

Lectures that assume it

8

Connections

19

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

2 lecturers. 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.