Query Simplification: Graceful Degradation for Join-Order Optimization

Summary: New approach to join-order optimization: when exact planning is intractable on large queries, simplify the join graph within a time budget. Safe-first, then riskier simplifications enable optimal results, with a directing strategy and graceful degradation. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 4135
Venue: SIGMOD
Year: 2009
Pagerank: 5.9600502e-05
Overall Rank: 4,738 | 67.04%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Thomas Neumann

Incoming Citations (Sorted by Pagerank)

Showing 15 of 15 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
71	How Good Are Query Optimizers, Really?	2016	VLDB	0.00059038975
1,105	Cardinality Estimation Done Right: Index-Based Join Sampling	2017	CIDR	0.00013990395
1,619	Adaptive Optimization of Very Large Join Queries	2018	SIGMOD	0.00011111678
3,918	On Optimizing Operator Fusion Plans for Large-Scale Machine Learning in SystemML	2018	VLDB	6.6315176e-05
5,037	Keep It Simple: Testing Databases via Differential Query Plans	2024	SIGMOD	5.7434825e-05
5,194	Bitvector-aware Query Optimization for Decision Support Queries	2020	SIGMOD	5.6368209e-05
5,626	Ready to Leap (by Co-Design)? Join Order Optimisation on Quantum Hardware	2023	SIGMOD	5.4044935e-05
7,486	Quantum-Inspired Digital Annealing for Join Ordering	2024	VLDB	4.7180617e-05
8,164	Efficiently Computing Join Orders with Heuristic Search	2023	SIGMOD	4.5718104e-05
9,299	Engineering High-Performance Database Engines	2014	VLDB	4.3587894e-05
10,283	Hybrid Mixed Integer Linear Programming for Large-Scale Join Order Optimisation	2026	VLDB	4.1945683e-05
10,591	Accio: Bolt-on Query Federation	2025	VLDB	4.1945683e-05
10,942	Sub-optimal Join Order Identification with L1-error	2024	SIGMOD	4.1945683e-05
10,987	DPconv: Super-Polynomially Faster Join Ordering	2024	SIGMOD	4.1945683e-05
11,132	A Branch-&-Bound Algorithm for Fractional Hypertree Decomposition	2024	VLDB	4.1945683e-05

Outgoing Citations (Sorted by Pagerank)

Showing 10 of 10 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
143	Optimization of Nonrecursive Queries	1986	VLDB	0.00041510555
387	Optimization of Large Join Queries	1988	SIGMOD	0.0002471967
399	Randomized Algorithms For Optimizing Large Join Queries	1990	SIGMOD	0.00024315433
423	Measuring the Complexity of Join Enumeration in Query Optimization	1990	VLDB	0.00023669348
978	Rapid Bushy Join-order Optimization with Cartesian Products	1996	SIGMOD	0.00014881073
1,341	Dynamic Programming Strikes Back	2008	SIGMOD	0.00012486285
1,826	Analysis of Two Existing and One New Dynamic Programming Algorithm for the Generation of Optimal Bushy Join Trees without Cross Products	2006	VLDB	0.00010400425
2,050	Optimal Top-Down Join Enumeration	2007	SIGMOD	9.6886663e-05
3,048	Fast, Randomized Join-Order Selection — Why Use Transformations?	1994	VLDB	7.6543116e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
1,572	Reverse Engineering Complex Join Queries	2013	SIGMOD	0.00011298251
8,784	SQL Query Optimization: Reordering for a General Class of Queries	1996	SIGMOD	4.4527694e-05
4,194	On the Complexity of Approximate Query Optimization	2002	PODS	6.3697822e-05
387	Optimization of Large Join Queries	1988	SIGMOD	0.0002471967
143	Optimization of Nonrecursive Queries	1986	VLDB	0.00041510555
71	How Good Are Query Optimizers, Really?	2016	VLDB	0.00059038975
11,705	Improving Join Reorderability with Compensation Operators	2018	SIGMOD	4.1945683e-05
4,523	Simplicity Done Right for Join Ordering	2021	CIDR	6.1135504e-05
8,164	Efficiently Computing Join Orders with Heuristic Search	2023	SIGMOD	4.5718104e-05
1,619	Adaptive Optimization of Very Large Join Queries	2018	SIGMOD	0.00011111678