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.
Lecture
Query Optimization: Heuristics and Cost-based Strategies
Description
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.
Official source
About this result
This page is automatically generated and may contain information that is not correct, complete, up-to-date, or relevant to your search query. The same applies to every other page on this website. Please make sure to verify the information with EPFL's official sources.