Query Optimizer Implementations - Part 2 - Lecture 17
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only! Grab it Explore advanced query optimizer implementations in this lecture from CMU's Advanced Database Systems course. Delve into the history of query optimizers, comparing top-down and bottom-up approaches. Learn about logical pre-optimization, physical operators, and real-world issues in query optimization. Examine reordering techniques, permutations, and the Cascades framework. Investigate extensions from the Volcano optimizer, including expressions, groups, and multi-expressions. Understand transformation rules and their application through examples. Study the graph data structure used in query optimization, and explore concepts of optimality in query planning. Gain insights into the intricacies of transformation rules and the Cascades framework from Prof. Andy Pavlo's comprehensive presentation.