Completed
Intro
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Query Optimizer Implementations - Part 1 - Lecture 16
Automatically move to the next video in the Classroom when playback concludes
- 1 Intro
- 2 Query Optimizer
- 3 Whats Next
- 4 Background
- 5 Overview
- 6 Logical Plan Physical Plan
- 7 Algebra Equivalencies
- 8 Optimal Physical Plan
- 9 Cost Model Assessment
- 10 Design Decisions
- 11 Query Optimizer Scope
- 12 Prepared Statements
- 13 Plan Stability
- 14 When to Stop Searching
- 15 Different Approaches
- 16 Simplest Approach
- 17 Magic Constants
- 18 CostBased Search
- 19 Bottoms Up Search
- 20 Aggregation
- 21 Postgres
- 22 Random Algorithm
- 23 simulated annealing
- 24 link