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 optimization strategies for OLAP queries, focusing on heuristic-based optimization and the INGRES optimizer. It explains the process of transforming logical operators into a physical plan, emphasizing the importance of join ordering based on cardinality. The instructor discusses the advantages and disadvantages of heuristic-based optimization, the use of static rules, and the significance of selectivity estimates and cost estimation in query optimization.