Sign inSign in
ConceptSystems & CS

Star/Snowflake query optimization

Transforming queries joining a fact table with multiple dimension tables into a left- or right-deep join tree ordered from most to least selective to avoid exploring bushy plans.
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.

Join trees1Selectivity1

Lecturers

1

    Connections

    2

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

    Concept1

    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.