Join Algorithms: Hash, Sort-Merge, Nested Loop Joins - Lecture 12
Offered By: CMU Database Group via YouTube
Course Description
Overview
Explore the fundamental join algorithms used in database systems, including hash joins, sort-merge joins, and nested loop joins, in this comprehensive lecture from Carnegie Mellon University's Intro to Database Systems course. Delve into the intricacies of each algorithm, understanding their strengths, weaknesses, and optimal use cases. Learn how these join techniques impact query performance and efficiency in relational database management systems. Gain insights from Professor Andy Pavlo's expertise as he breaks down complex concepts and provides practical examples. Access accompanying slides and notes for further study and reference.
Syllabus
#12 - Join Algorithms: Hash, Sort-Merge, Nested Loop Joins (CMU Intro to Database Systems)
Taught by
CMU Database Group
Related Courses
Advanced Database Systems - Spring 2016Carnegie Mellon University via YouTube Intro to Database Systems - Fall 2021
Carnegie Mellon University via YouTube Parallel Hash Join Algorithms - Lecture 9
CMU Database Group via YouTube Query Planning and Optimization - Lecture 14
CMU Database Group via YouTube Query Execution Part 1 - Lecture 12
CMU Database Group via YouTube