Query Optimizer Implementations - Part 1 - Lecture 16

Query Optimizer Implementations - Part 1 - Lecture 16

CMU Database Group via YouTube Direct link

simulated annealing

23 of 24

23 of 24

simulated annealing

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. 1 Intro
  2. 2 Query Optimizer
  3. 3 Whats Next
  4. 4 Background
  5. 5 Overview
  6. 6 Logical Plan Physical Plan
  7. 7 Algebra Equivalencies
  8. 8 Optimal Physical Plan
  9. 9 Cost Model Assessment
  10. 10 Design Decisions
  11. 11 Query Optimizer Scope
  12. 12 Prepared Statements
  13. 13 Plan Stability
  14. 14 When to Stop Searching
  15. 15 Different Approaches
  16. 16 Simplest Approach
  17. 17 Magic Constants
  18. 18 CostBased Search
  19. 19 Bottoms Up Search
  20. 20 Aggregation
  21. 21 Postgres
  22. 22 Random Algorithm
  23. 23 simulated annealing
  24. 24 link

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.