DBScholar

Back to papers

Analyzing Plan Diagrams of Database Query Optimizers

Summary: Analyzes plan diagrams from commercial optimizers on TPC-H queries, revealing extremely fine-grained choices, intricate nonlinear region boundaries, and nonmonotonic cost behavior. Challenges foundational assumptions of parametric query optimization and exposes widespread near-equivalent plan alternatives. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
hcf9f51042efdfb75
Venue
VLDB
Year
2005
Pagerank
0.00012629969
Overall Rank
995 | 93.32%
DOI
-

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{reddy_vldb05,
        title = {{Analyzing Plan Diagrams of Database Query Optimizers}},
        author = {Reddy, Naveen and Haritsa, Jayant R.},
        journal = {PVLDB},
        series = {{VLDB} '05},
        pages = {1228--1239},
        year = {2005}
}

Incoming Citations (Sorted by Pagerank)

Showing 31 of 31 citing papers.

Rank Citing Paper Year Venue Pagerank
386 Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors 2009 VLDB 0.00019446558
1,258 Sampling-Based Query Re-Optimization 2016 SIGMOD 0.00011308863
1,509 Self-Tuning, GPU-Accelerated Kernel Density Models for Multidimensional Selectivity Estimation 2015 SIGMOD 0.00010436933
1,607 The Picasso Database Query Optimizer Visualizer 2010 VLDB 0.00010085995
1,815 CoPhy: A Scalable, Portable, and Interactive Index Advisor for Large Workloads 2011 VLDB 9.5756946e-05
2,025 Efficient Use of the Query Optimizer for Automated Physical Design 2007 VLDB 9.1650298e-05
2,209 Lero: A Learning-to-Rank Query Optimizer 2023 VLDB 8.8360101e-05
2,217 Estimating Join Selectivities using Bandwidth-Optimized Kernel Density Models 2017 VLDB 8.8151982e-05
2,524 Multi-Objective Parametric Query Optimization 2015 VLDB 8.3400278e-05
2,890 Query Optimizers: Time to Rethink the Contract? 2009 SIGMOD 7.9010819e-05
3,209 Why You Should Run TPC-DS:A Workload Analysis 2007 VLDB 7.5353129e-05
3,396 Variance Aware Optimization of Parameterized Queries 2010 SIGMOD 7.3386533e-05
3,527 Identifying Robust Plans through Plan Diagram Reduction 2008 VLDB 7.2283486e-05
4,191 Kepler: Robust Learning for Faster Parametric Query Optimization 2023 SIGMOD 6.7425275e-05
4,659 On the Production of Anorexic Plan Diagrams 2007 VLDB 6.4794607e-05
4,857 Efficiently Approximating Query Optimizer Plan Diagrams 2008 VLDB 6.3772435e-05
5,042 Leveraging Query Logs and Machine Learning for Parametric Query Optimization 2022 VLDB 6.2995365e-05
5,081 Leveraging Re-costing for Online Optimization of Parameterized Queries with Guarantees 2017 SIGMOD 6.2830143e-05
5,658 Uncertainty Aware Query Execution Time Prediction 2014 VLDB 6.0460211e-05
7,413 POLAR: Adaptive and Non-invasive Join Order Selection via Plans of Least Resistance 2024 VLDB 5.5316834e-05
7,904 DISTILL: Low-Overhead Data-Driven Techniques for Filtering and Costing Indexes for Scalable Index Tuning 2022 VLDB 5.4277674e-05
8,393 PARQO: Penalty-Aware Robust Plan Selection in Query Optimization 2024 VLDB 5.3387995e-05
9,725 APQO: An Adaptive Framework for Parametric Query Optimization 2026 SIGMOD 5.1325223e-05
9,735 PAR2QO: Parametric Penalty-Aware Robust Query Optimization 2025 VLDB 5.1325223e-05
10,343 An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL 2025 SIGMOD 5.0176429e-05
10,703 Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking 2026 SIGMOD 4.9769913e-05
11,405 Hint-QPT: Hints for Robust Query Performance Tuning 2025 VLDB 4.9769913e-05
11,459 RankPQO: Learning-to-Rank for Parametric Query Optimization 2025 VLDB 4.9769913e-05
12,490 AZDBLab: A Laboratory Information System for Large-Scale Empirical DBMS Studies 2014 VLDB 4.9769913e-05
12,783 Visualizing the robustness of query execution 2009 CIDR 4.9769913e-05
12,872 Dependable Cardinality Forecasts for XQuery 2008 VLDB 4.9769913e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 13 of 13 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.0023943337
98 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034099838
288 Optimization of Dynamic Query Evaluation Plans 1994 SIGMOD 0.00021964339
792 Parametric Query Optimization 1992 VLDB 0.00013938197
1,298 Parametric Query Optimization for Linear and Piecewise Linear Cost Functions 2002 VLDB 0.00011122244
1,449 Design and Analysis of Parametric Query Optimization Algorithms 1998 VLDB 0.00010616486
1,612 AniPQO: Almost Non-intrusive Parametric Query Optimization for Nonlinear Cost Functions 2003 VLDB 0.00010068388
1,788 Plan Selection based on Query Clustering 2002 VLDB 9.6275306e-05
4,040 Counting, Enumerating, and Sampling of Execution Plans in a Cost-Based Query Optimizer 2000 SIGMOD 6.8357679e-05
4,417 Estimating Compilation Time of a Query Optimizer 2003 SIGMOD 6.6064397e-05
4,894 A Characterization of the Sensitivity of Query Optimization to Storage Access Cost Parameters 2003 SIGMOD 6.3648584e-05
6,462 Green Query Optimization: Taming Query Optimization Overheads through Plan Recycling 2004 VLDB 5.7742958e-05
14,245 PLASTIC: Reducing Query Optimization Overheads through Plan Recycling 2003 SIGMOD -
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 2,686 Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection 2022 VLDB
2 4,894 A Characterization of the Sensitivity of Query Optimization to Storage Access Cost Parameters 2003 SIGMOD
3 2,524 Multi-Objective Parametric Query Optimization 2015 VLDB
4 288 Optimization of Dynamic Query Evaluation Plans 1994 SIGMOD
5 1,449 Design and Analysis of Parametric Query Optimization Algorithms 1998 VLDB
6 5,988 On the Stability of Plan Costs and the Costs of Plan Stability 2010 VLDB
7 272 An Overview of Query Optimization in Relational Systems 1998 PODS
8 4,659 On the Production of Anorexic Plan Diagrams 2007 VLDB
9 3,527 Identifying Robust Plans through Plan Diagram Reduction 2008 VLDB
10 4,857 Efficiently Approximating Query Optimizer Plan Diagrams 2008 VLDB