Are you an EPFL student looking for a semester project?
Work with us on data science and visualisation projects, and deploy your project as an app on top of Graph Search.
This lecture covers query processing operations such as selections, projections, nested loop joins, index nested loop joins, hash joins, sort-merge joins, and general joins. It explains the concepts behind each operation, including their costs and benefits. The lecture also delves into set operations, aggregate operations, and the impact of buffering on query performance. Different join conditions and their implications are discussed, along with strategies for optimizing query performance. The instructor emphasizes the importance of choosing the most suitable operation based on system statistics to enhance query efficiency.
This video is available exclusively on Mediaspace for a restricted audience. Please log in to MediaSpace to access it if you have the necessary permissions.
Watch on Mediaspace