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,300 | The Picasso Database Query Optimizer Visualizer | 2010 | VLDB | 0.00012733214 |
| 2,659 | Multi-Objective Parametric Query Optimization | 2015 | VLDB | 8.3604734e-05 |
| 6,479 | Leveraging Re-costing for Online Optimization of Parameterized Queries with Guarantees | 2017 | SIGMOD | 5.0483805e-05 |
| 6,763 | Robustness Metrics for Relational Query Execution Plans | 2018 | VLDB | 4.9338479e-05 |
| 7,126 | Debunking the Myth of Join Ordering: Toward Robust SQL Analytics | 2025 | SIGMOD | 4.8232367e-05 |
| 8,448 | PARQO: Penalty-Aware Robust Plan Selection in Query Optimization | 2024 | VLDB | 4.5100508e-05 |
| 9,187 | POLAR: Adaptive and Non-invasive Join Order Selection via Plans of Least Resistance | 2024 | VLDB | 4.3780059e-05 |
| 10,751 | PAR2QO: Parametric Penalty-Aware Robust Query Optimization | 2025 | VLDB | 4.1945683e-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.0040449103 |
| 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 |
| 650 | Robust Query Processing through Progressive Optimization | 2004 | SIGMOD | 0.00018659177 |
| 684 | Towards a Robust Query Optimizer: A Principled and Practical Approach | 2005 | SIGMOD | 0.00018179769 |
| 1,236 | Least Expected Cost Query Optimization: An Exercise in Utility | 1999 | PODS | 0.00013117798 |
| 1,272 | Proactive Re-Optimization | 2005 | SIGMOD | 0.00012920076 |
| 1,986 | AniPQO: Almost Non-intrusive Parametric Query Optimization for Nonlinear Cost Functions | 2003 | VLDB | 9.8536784e-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 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 9,960 | An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL | 2025 | SIGMOD | 4.2294678e-05 |
| 5,340 | Efficiently Approximating Query Optimizer Plan Diagrams | 2008 | VLDB | 5.5623066e-05 |
| 1,547 | Lightweight Graphical Models for Selectivity Estimation Without Independence Assumptions | 2011 | VLDB | 0.00011442359 |
| 1,962 | Plan Selection based on Query Clustering | 2002 | VLDB | 9.950467e-05 |
| 5,466 | On the Production of Anorexic Plan Diagrams | 2007 | VLDB | 5.4909203e-05 |
| 3,727 | Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection | 2022 | VLDB | 6.8141709e-05 |
| 339 | Optimization of Dynamic Query Evaluation Plans | 1994 | SIGMOD | 0.00026851113 |
| 2,631 | Plan Bouquets: Query Processing without Selectivity Estimation | 2014 | SIGMOD | 8.4101843e-05 |
| 1,070 | Analyzing Plan Diagrams of Database Query Optimizers | 2005 | VLDB | 0.00014316791 |
| 4,348 | Identifying Robust Plans through Plan Diagram Reduction | 2008 | VLDB | 6.2660237e-05 |