Database Paper Browser

Back to papers

Identifying Robust Plans through Plan Diagram Reduction

Summary: Identifies robust plans by reducing dense plan diagrams to anorexic equivalents that resist selectivity. Offers a mathematical criterion for safe plan reduction; TPC-H/DS studies show robustness but occasional degradations; implemented in Picasso. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
9742
Venue
VLDB
Year
2008
Pagerank
6.2680535e-05
Overall Rank
4,342 | 69.83%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 22 of 22 citing papers.

Rank Citing Paper Year Venue Pagerank
1,297 The Picasso Database Query Optimizer Visualizer 2010 VLDB 0.00012732768
2,154 SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning 2018 VLDB 9.4176683e-05
2,222 SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning 2019 SIGMOD 9.2598438e-05
2,632 Plan Bouquets: Query Processing without Selectivity Estimation 2014 SIGMOD 8.4153283e-05
3,343 Toward Computational Fact-Checking 2014 VLDB 7.196079e-05
3,345 Lero: A Learning-to-Rank Query Optimizer 2023 VLDB 7.1908499e-05
5,344 Efficiently Approximating Query Optimizer Plan Diagrams 2008 VLDB 5.5579641e-05
5,941 Eraser: Eliminating Performance Regression on Learned Query Optimizer 2024 VLDB 5.2594013e-05
6,277 Uncertainty Aware Query Execution Time Prediction 2014 VLDB 5.1260947e-05
6,561 On the Stability of Plan Costs and the Costs of Plan Stability 2010 VLDB 5.0055336e-05
6,763 Robustness Metrics for Relational Query Execution Plans 2018 VLDB 4.9291549e-05
7,122 Debunking the Myth of Join Ordering: Toward Robust SQL Analytics 2025 SIGMOD 4.8199209e-05
8,130 Robust Query Processing: Mission Possible 2020 VLDB 4.5746794e-05
8,193 On the Calculation of Optimality Ranges for Relational Query Execution Plans 2018 SIGMOD 4.5575291e-05
8,440 PARQO: Penalty-Aware Robust Plan Selection in Query Optimization 2024 VLDB 4.505741e-05
8,638 A Concave Path to Low-overhead Robust Query Processing 2018 VLDB 4.4750742e-05
9,191 POLAR: Adaptive and Non-invasive Join Order Selection via Plans of Least Resistance 2024 VLDB 4.3738237e-05
9,692 ROME: Robust Query Optimization via Parallel Multi-Plan Execution 2024 SIGMOD 4.2986161e-05
10,047 AgentTune: An Agent-Based Large Language Model Framework for Database Knob Tuning 2026 SIGMOD 4.1905499e-05
10,050 APQO: An Adaptive Framework for Parametric Query Optimization 2026 SIGMOD 4.1905499e-05
10,757 PAR2QO: Parametric Penalty-Aware Robust Query Optimization 2025 VLDB 4.1905499e-05
12,299 Visualizing the robustness of query execution 2009 CIDR 4.1905499e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 16 of 16 cited papers.

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

Rank Cited Paper Year Venue Pagerank
100 On the Propagation of Errors in the Size of Join Results 1991 SIGMOD 0.00050033475
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
269 R* Optimizer Validation and Performance Evaluation for Local Queries 1986 SIGMOD 0.00029665158
527 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD 0.00020862475
650 Robust Query Processing through Progressive Optimization 2004 SIGMOD 0.0001865144
680 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00018193263
1,064 Analyzing Plan Diagrams of Database Query Optimizers 2005 VLDB 0.00014348262
1,234 Least Expected Cost Query Optimization: An Exercise in Utility 1999 PODS 0.00013115865
1,268 Proactive Re-Optimization 2005 SIGMOD 0.00012914584
1,644 Parametric Query Optimization for Linear and Piecewise Linear Cost Functions 2002 VLDB 0.0001102889
1,990 AniPQO: Almost Non-intrusive Parametric Query Optimization for Nonlinear Cost Functions 2003 VLDB 9.8491124e-05
2,187 Least Expected Cost Query Optimization: What Can We Expect? 2002 PODS 9.3429142e-05
5,344 Efficiently Approximating Query Optimizer Plan Diagrams 2008 VLDB 5.5579641e-05
5,476 On the Production of Anorexic Plan Diagrams 2007 VLDB 5.4866057e-05
6,384 Proactive Re-optimization with Rio 2005 SIGMOD 5.0828986e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
8,638 A Concave Path to Low-overhead Robust Query Processing 2018 VLDB 4.4750742e-05
342 Optimization of Dynamic Query Evaluation Plans 1994 SIGMOD 0.00026836424
10,635 Robust Plan Evaluation based on Approximate Probabilistic Machine Learning 2025 VLDB 4.1905499e-05
680 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00018193263
12,299 Visualizing the robustness of query execution 2009 CIDR 4.1905499e-05
6,763 Robustness Metrics for Relational Query Execution Plans 2018 VLDB 4.9291549e-05
5,344 Efficiently Approximating Query Optimizer Plan Diagrams 2008 VLDB 5.5579641e-05
6,561 On the Stability of Plan Costs and the Costs of Plan Stability 2010 VLDB 5.0055336e-05
5,476 On the Production of Anorexic Plan Diagrams 2007 VLDB 5.4866057e-05
1,064 Analyzing Plan Diagrams of Database Query Optimizers 2005 VLDB 0.00014348262