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 the process of query optimization, starting from logical query plans to physical query plans. It explains the steps involved in query transformation, select-project-join optimization, and query rewriting. The lecture also delves into the estimation of costs for different query plans and the importance of statistics and catalogs in the optimization process.