On the Stability of Plan Costs and the Costs of Plan Stability
Summary: Parametrized robust plan generation/selection replaces pure cost-based choices with near-optimal, stable plans under selectivity errors. Implemented in PostgreSQL and evaluated on TPC-H/DS templates; results show robustness with minimal overhead and enable anorexic plan diagrams. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. M. Abhirama
- 2. Sourjya Bhaumik
- 3. Atreyee Dey
- 4. Harsh Shrimal
- 5. Jayant R. Haritsa
Incoming Citations (Sorted by Pagerank)
Showing 8 of 8 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,297 | The Picasso Database Query Optimizer Visualizer | 2010 | VLDB | 0.00012732768 |
| 2,652 | Multi-Objective Parametric Query Optimization | 2015 | VLDB | 8.3662031e-05 |
| 6,471 | Leveraging Re-costing for Online Optimization of Parameterized Queries with Guarantees | 2017 | SIGMOD | 5.0438582e-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,440 | PARQO: Penalty-Aware Robust Plan Selection in Query Optimization | 2024 | VLDB | 4.505741e-05 |
| 9,191 | POLAR: Adaptive and Non-invasive Join Order Selection via Plans of Least Resistance | 2024 | VLDB | 4.3738237e-05 |
| 10,757 | PAR2QO: Parametric Penalty-Aware Robust Query Optimization | 2025 | VLDB | 4.1905499e-05 |
Previous
Page 1 / 1
Next
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.0040465394 |
| 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 |
| 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,234 | Least Expected Cost Query Optimization: An Exercise in Utility | 1999 | PODS | 0.00013115865 |
| 1,268 | Proactive Re-Optimization | 2005 | SIGMOD | 0.00012914584 |
| 1,990 | AniPQO: Almost Non-intrusive Parametric Query Optimization for Nonlinear Cost Functions | 2003 | VLDB | 9.8491124e-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 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 9,959 | An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL | 2025 | SIGMOD | 4.2254157e-05 |
| 5,344 | Efficiently Approximating Query Optimizer Plan Diagrams | 2008 | VLDB | 5.5579641e-05 |
| 1,961 | Plan Selection based on Query Clustering | 2002 | VLDB | 9.9464221e-05 |
| 1,536 | Lightweight Graphical Models for Selectivity Estimation Without Independence Assumptions | 2011 | VLDB | 0.00011458359 |
| 5,476 | On the Production of Anorexic Plan Diagrams | 2007 | VLDB | 5.4866057e-05 |
| 3,729 | Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection | 2022 | VLDB | 6.8078013e-05 |
| 342 | Optimization of Dynamic Query Evaluation Plans | 1994 | SIGMOD | 0.00026836424 |
| 2,632 | Plan Bouquets: Query Processing without Selectivity Estimation | 2014 | SIGMOD | 8.4153283e-05 |
| 1,064 | Analyzing Plan Diagrams of Database Query Optimizers | 2005 | VLDB | 0.00014348262 |
| 4,342 | Identifying Robust Plans through Plan Diagram Reduction | 2008 | VLDB | 6.2680535e-05 |