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.
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
1Connections
2The lectures that define it or assume it, and the concepts next to it.