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: 5462
Venue: SIGMOD
Year: 2018
Pagerank: 4.557937e-05
Overall Rank: 8,213 | 42.87%
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.9338479e-05
7,305	Tempura: A General Cost-Based Optimizer Framework for Incremental Data Processing	2021	VLDB	4.7678776e-05
7,854	dbET: Execution Time Distribution-based Plan Selection	2023	SIGMOD	4.6350172e-05
8,448	PARQO: Penalty-Aware Robust Plan Selection in Query Optimization	2024	VLDB	4.5100508e-05
9,464	Memory Efficient Scheduling of Query Pipeline Execution	2022	CIDR	4.3355852e-05
9,662	Efficient Query Re-optimization with Judicious Subquery Selections	2023	SIGMOD	4.3097631e-05
10,751	PAR2QO: Parametric Penalty-Aware Robust Query Optimization	2025	VLDB	4.1945683e-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.0040449103
71	How Good Are Query Optimizers, Really?	2016	VLDB	0.00059038975
182	LEO - DB2's LEarning Optimizer	2001	VLDB	0.00036962631
220	Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans	1998	SIGMOD	0.00033194808
423	Measuring the Complexity of Join Enumeration in Query Optimization	1990	VLDB	0.00023669348
650	Robust Query Processing through Progressive Optimization	2004	SIGMOD	0.00018659177
1,272	Proactive Re-Optimization	2005	SIGMOD	0.00012920076
1,341	Dynamic Programming Strikes Back	2008	SIGMOD	0.00012486285
1,647	Parametric Query Optimization for Linear and Piecewise Linear Cost Functions	2002	VLDB	0.00011033757
2,050	Optimal Top-Down Join Enumeration	2007	SIGMOD	9.6886663e-05
2,785	Counter Strike: Generic Top-Down Join Enumeration for Hypergraphs	2013	VLDB	8.1286814e-05
2,869	The Complexity of Transformation-Based Join Enumeration	1997	VLDB	7.9808408e-05
4,348	Identifying Robust Plans through Plan Diagram Reduction	2008	VLDB	6.2660237e-05
5,466	On the Production of Anorexic Plan Diagrams	2007	VLDB	5.4909203e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
220	Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans	1998	SIGMOD	0.00033194808
454	An Overview of Query Optimization in Relational Systems	1998	PODS	0.00022734812
790	Exploiting Statistics on Query Expressions for Optimization	2002	SIGMOD	0.0001663283
3,651	Conditional Selectivity for Statistics on Query Expressions	2004	SIGMOD	6.8768678e-05
6,763	Robustness Metrics for Relational Query Execution Plans	2018	VLDB	4.9338479e-05
684	Towards a Robust Query Optimizer: A Principled and Practical Approach	2005	SIGMOD	0.00018179769
71	How Good Are Query Optimizers, Really?	2016	VLDB	0.00059038975
5,685	Exact Cardinality Query Optimization with Bounded Execution Cost	2019	SIGMOD	5.3717535e-05
3,952	Exact Cardinality Query Optimization for Optimizer Testing	2009	VLDB	6.5939652e-05
629	Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors	2009	VLDB	0.00018942366