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: 5463
Venue: SIGMOD
Year: 2018
Pagerank: 4.5575291e-05
Overall Rank: 8,193 | 43.06%
DOI: 10.1145/3183713.3183742

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 7 of 7 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
6,763	Robustness Metrics for Relational Query Execution Plans	2018	VLDB	4.9291549e-05
7,302	Tempura: A General Cost-Based Optimizer Framework for Incremental Data Processing	2021	VLDB	4.763304e-05
7,854	dbET: Execution Time Distribution-based Plan Selection	2023	SIGMOD	4.6306186e-05
8,440	PARQO: Penalty-Aware Robust Plan Selection in Query Optimization	2024	VLDB	4.505741e-05
9,466	Memory Efficient Scheduling of Query Pipeline Execution	2022	CIDR	4.3314303e-05
9,662	Efficient Query Re-optimization with Judicious Subquery Selections	2023	SIGMOD	4.3056334e-05
10,757	PAR2QO: Parametric Penalty-Aware Robust Query Optimization	2025	VLDB	4.1905499e-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.0040465394
71	How Good Are Query Optimizers, Really?	2016	VLDB	0.00059446482
181	LEO - DB2's LEarning Optimizer	2001	VLDB	0.00036970794
221	Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans	1998	SIGMOD	0.00033182072
422	Measuring the Complexity of Join Enumeration in Query Optimization	1990	VLDB	0.00023654556
650	Robust Query Processing through Progressive Optimization	2004	SIGMOD	0.0001865144
1,268	Proactive Re-Optimization	2005	SIGMOD	0.00012914584
1,344	Dynamic Programming Strikes Back	2008	SIGMOD	0.00012477274
1,644	Parametric Query Optimization for Linear and Piecewise Linear Cost Functions	2002	VLDB	0.0001102889
2,053	Optimal Top-Down Join Enumeration	2007	SIGMOD	9.682841e-05
2,778	Counter Strike: Generic Top-Down Join Enumeration for Hypergraphs	2013	VLDB	8.1345892e-05
2,878	The Complexity of Transformation-Based Join Enumeration	1997	VLDB	7.9694937e-05
4,342	Identifying Robust Plans through Plan Diagram Reduction	2008	VLDB	6.2680535e-05
5,476	On the Production of Anorexic Plan Diagrams	2007	VLDB	5.4866057e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
221	Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans	1998	SIGMOD	0.00033182072
786	Exploiting Statistics on Query Expressions for Optimization	2002	SIGMOD	0.00016624743
454	An Overview of Query Optimization in Relational Systems	1998	PODS	0.00022796106
3,656	Conditional Selectivity for Statistics on Query Expressions	2004	SIGMOD	6.8712579e-05
6,763	Robustness Metrics for Relational Query Execution Plans	2018	VLDB	4.9291549e-05
680	Towards a Robust Query Optimizer: A Principled and Practical Approach	2005	SIGMOD	0.00018193263
71	How Good Are Query Optimizers, Really?	2016	VLDB	0.00059446482
5,696	Exact Cardinality Query Optimization with Bounded Execution Cost	2019	SIGMOD	5.367449e-05
3,943	Exact Cardinality Query Optimization for Optimizer Testing	2009	VLDB	6.6067351e-05
627	Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors	2009	VLDB	0.00018959896