On the Calculation of Optimality Ranges for Relational Query Execution Plans

Summary: Precise optimality ranges for intermediate cardinalities in plans; replaces fixed heuristics with bounds over all competing plans. Derives worst-case bounds on enumeration; real workloads need far fewer plans, enabling Mid-Query Re-Optimization gains. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 5524
Venue: SIGMOD
Year: 2018
Pagerank: 5.6041473e-05
Overall Rank: 7,495 | 48.58%
DOI: 10.1145/3183713.3183742

Incoming Non-self Citations Over Time

Authors

1. Florian Wolf (Ilmenau University of Technology; SAP)
2. Norman May (SAP)
3. Paul R. Willems (SAP)
4. Kai-Uwe Sattler (Ilmenau University of Technology)

BibTeX Citation

@inproceedings{wolf_sigmod18,
        title = {{On the Calculation of Optimality Ranges for Relational Query Execution Plans}},
        author = {Wolf, Florian and May, Norman and Willems, Paul R. and Sattler, Kai-Uwe},
        series = {{SIGMOD} '18},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3183713.3183742},
        url = {https://dl.acm.org/doi/10.1145/3183713.3183742},
        year = {2018}
}

Incoming Citations (Sorted by Pagerank)

Showing 8 of 8 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
6,019	Robustness Metrics for Relational Query Execution Plans	2018	VLDB	6.0060149e-05
6,626	Tempura: A General Cost-Based Optimizer Framework for Incremental Data Processing	2021	VLDB	5.8198723e-05
7,193	dbET: Execution Time Distribution-based Plan Selection	2023	SIGMOD	5.6770249e-05
8,305	PARQO: Penalty-Aware Robust Plan Selection in Query Optimization	2024	VLDB	5.4568571e-05
9,612	Memory Efficient Scheduling of Query Pipeline Execution	2022	CIDR	5.2449175e-05
9,756	Efficient Query Re-optimization with Judicious Subquery Selections	2023	SIGMOD	5.2258278e-05
10,151	Coresets for Robust Query Optimization	2026	PODS	5.093636e-05
10,986	PAR2QO: Parametric Penalty-Aware Robust Query Optimization	2025	VLDB	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 14 of 14 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
1	Access Path Selection in a Relational Database Management System	1979	SIGMOD	0.0024089429
18	How Good Are Query Optimizers, Really?	2016	VLDB	0.00059284255
100	LEO - DB2's LEarning Optimizer	2001	VLDB	0.00034385207
151	Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans	1998	SIGMOD	0.00029161879
316	Measuring the Complexity of Join Enumeration in Query Optimization	1990	VLDB	0.0002141607
492	Robust Query Processing through Progressive Optimization	2004	SIGMOD	0.0001756877
829	Proactive Re-Optimization	2005	SIGMOD	0.00013769838
1,013	Dynamic Programming Strikes Back	2008	SIGMOD	0.00012652549
1,321	Parametric Query Optimization for Linear and Piecewise Linear Cost Functions	2002	VLDB	0.00011162369
1,727	Optimal Top-Down Join Enumeration	2007	SIGMOD	9.91063e-05
2,275	Counter Strike: Generic Top-Down Join Enumeration for Hypergraphs	2013	VLDB	8.8196821e-05
2,627	The Complexity of Transformation-Based Join Enumeration	1997	VLDB	8.3284491e-05
3,506	Identifying Robust Plans through Plan Diagram Reduction	2008	VLDB	7.3581509e-05
4,616	On the Production of Anorexic Plan Diagrams	2007	VLDB	6.6048588e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	151	Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans	1998	SIGMOD
2	290	An Overview of Query Optimization in Relational Systems	1998	PODS
3	664	Exploiting Statistics on Query Expressions for Optimization	2002	SIGMOD
4	3,309	Conditional Selectivity for Statistics on Query Expressions	2004	SIGMOD
5	6,019	Robustness Metrics for Relational Query Execution Plans	2018	VLDB
6	566	Towards a Robust Query Optimizer: A Principled and Practical Approach	2005	SIGMOD
7	18	How Good Are Query Optimizers, Really?	2016	VLDB
8	5,137	Exact Cardinality Query Optimization with Bounded Execution Cost	2019	SIGMOD
9	3,426	Exact Cardinality Query Optimization for Optimizer Testing	2009	VLDB
10	388	Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors	2009	VLDB