Sign inSign in
ConceptSystems & CS

Holistic Unnesting

An algorithm that removes all dependent joins in a top-down pass through the query plan after identifying them first.
as Andy Pavlo defines itCarnegie Mellon University
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.

DAG query plans1Dependent join1Operator trees1Query optimization plans1Query plan1Subqueries1

Lecturers

1

    Connections

    3

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

    Concepts2

    Lecture1

    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.