Optimizer
- Michael Jungmair, et al., PVLDB 2022 Designing an Open Framework for Query Optimization and Compilation
- propose to extend the scope of query compilers to also perform query optimization as a sequence of compiler passes
- An Overview of Query Optimization in Relational Systems
- Access path selection in a relational database management system
- The Volcano Optimizer Generator: Extensibility and Efficient Search
- The Cascades Framework for Query Optimization
Optional readings
- Bailu Ding, et al. Foundations and Trends® in Databases, 2024, Vol 14 Extensible Query Optimizers in Practice
- Michael S. Kester, et al., SIGMOD '17 Access Path Selection in Main-Memory Optimized Data Systems: Should I Scan or Should I Probe?