Back to papers
Leveraging Query Logs and Machine Learning for Parametric Query Optimization
Summary: Decouples PQO into populateCache (small plan set) and getPlan (choose cached plans) using log costs. ML-based getPlan latency ~210 μs with sub-optimality 1.05–1.3; populateCache remains efficient and scales to large logs.
(summarized by gpt-5-nano on Feb 09 2026)
- Paper ID
- 12911
- Venue
- VLDB
- Year
- 2022
- Pagerank
- 4.976781e-05
- Overall Rank
- 6,639 | 53.86%
- DOI
-
10.14778/3494124.3494126
Incoming Non-self Citations Over Time
Incoming Citations (Sorted by Pagerank)
Showing 10 of 10 citing papers.
| Rank |
Citing Paper |
Year |
Venue |
Pagerank |
| 5,373 |
Fine-Grained Modeling and Optimization for Intelligent Resource Management in Big Data Processing |
2022 |
VLDB |
5.5410059e-05 |
| 5,412 |
Kepler: Robust Learning for Faster Parametric Query Optimization |
2023 |
SIGMOD |
5.5200608e-05 |
| 8,003 |
The Holon Approach for Simultaneously Tuning Multiple Components in a Self-Driving Database Management System with Machine Learning via Synthesized Proto-Actions |
2024 |
VLDB |
4.6049527e-05 |
| 8,440 |
PARQO: Penalty-Aware Robust Plan Selection in Query Optimization |
2024 |
VLDB |
4.505741e-05 |
| 8,854 |
Optimizing the cloud? Don't train models. Build oracles! |
2024 |
CIDR |
4.4306537e-05 |
| 9,959 |
An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL |
2025 |
SIGMOD |
4.2254157e-05 |
| 10,050 |
APQO: An Adaptive Framework for Parametric Query Optimization |
2026 |
SIGMOD |
4.1905499e-05 |
| 10,219 |
Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking |
2026 |
SIGMOD |
4.1905499e-05 |
| 10,757 |
PAR2QO: Parametric Penalty-Aware Robust Query Optimization |
2025 |
VLDB |
4.1905499e-05 |
| 10,884 |
RankPQO: Learning-to-Rank for Parametric Query Optimization |
2025 |
VLDB |
4.1905499e-05 |
Outgoing Citations (Sorted by Pagerank)
Showing 19 of 19 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank |
Cited Paper |
Year |
Venue |
Pagerank |
| 329 |
Neo: A Learned Query Optimizer |
2019 |
VLDB |
0.00027301488 |
| 342 |
Optimization of Dynamic Query Evaluation Plans |
1994 |
SIGMOD |
0.00026836424 |
| 509 |
Dynamic Query Evaluation Plans |
1989 |
SIGMOD |
0.00021463676 |
| 634 |
Bao: Making Learned Query Optimization Practical |
2021 |
SIGMOD |
0.00018844568 |
| 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,239 |
Selectivity Estimation for Range Predicates using Lightweight Models |
2019 |
VLDB |
0.00013091459 |
| 1,644 |
Parametric Query Optimization for Linear and Piecewise Linear Cost Functions |
2002 |
VLDB |
0.0001102889 |
| 1,725 |
Design and Analysis of Parametric Query Optimization Algorithms |
1998 |
VLDB |
0.0001073575 |
| 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 |
| 3,402 |
Query Optimizers: Time to Rethink the Contract? |
2009 |
SIGMOD |
7.134261e-05 |
| 3,955 |
Efficiently Approximating Selectivity Functions using Low Overhead Regression Models |
2020 |
VLDB |
6.5895015e-05 |
| 4,480 |
Variance Aware Optimization of Parameterized Queries |
2010 |
SIGMOD |
6.1433292e-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,142 |
Closing The Query Processing Loop in Oracle 11g |
2008 |
VLDB |
5.186791e-05 |
| 6,471 |
Leveraging Re-costing for Online Optimization of Parameterized Queries with Guarantees |
2017 |
SIGMOD |
5.0438582e-05 |
| 8,184 |
Dynamic Plan Generation for Parameterized Queries |
2009 |
SIGMOD |
4.5615174e-05 |
Semantically Similar Papers