Back to papers
RankPQO: Learning-to-Rank for Parametric Query Optimization
Summary: RankPQO: hybrid enumeration altering cardinalities and join orders to generate compact, diverse plan sets for parametric queries. Uses learning-to-rank (vs. latency regression) to robustly pick plans under varying bindings; in PostgreSQL: up to 2.57x optimizer speedup and 1.36x over baselines.
(summarized by gpt-5-mini on Feb 09 2026)
- Paper ID
- 14244
- Venue
- VLDB
- Year
- 2025
- Pagerank
- 4.1905499e-05
- Overall Rank
- 10,884 | 24.36%
- DOI
-
10.14778/3712221.3712248
Incoming Non-self Citations Over Time
No non-self incoming citations found for this paper in this database.
Incoming Citations (Sorted by Pagerank)
Showing 2 of 2 citing papers.
Outgoing Citations (Sorted by Pagerank)
Showing 25 of 25 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank |
Cited Paper |
Year |
Venue |
Pagerank |
| 71 |
How Good Are Query Optimizers, Really? |
2016 |
VLDB |
0.00059446482 |
| 329 |
Neo: A Learned Query Optimizer |
2019 |
VLDB |
0.00027301488 |
| 634 |
Bao: Making Learned Query Optimization Practical |
2021 |
SIGMOD |
0.00018844568 |
| 804 |
An End-to-End Learning-based Cost Estimator |
2020 |
VLDB |
0.0001643674 |
| 1,064 |
Analyzing Plan Diagrams of Database Query Optimizers |
2005 |
VLDB |
0.00014348262 |
| 1,638 |
Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation |
2022 |
VLDB |
0.00011050093 |
| 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,090 |
Balsa: Learning a Query Optimizer Without Expert Demonstrations |
2022 |
SIGMOD |
9.5668285e-05 |
| 2,937 |
DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems |
2021 |
VLDB |
7.8552033e-05 |
| 3,167 |
QueryFormer: A Tree Transformer Model for Query Plan Representation |
2022 |
VLDB |
7.4561078e-05 |
| 3,269 |
Learned Cardinality Estimation: An In-depth Study |
2022 |
SIGMOD |
7.3026051e-05 |
| 3,345 |
Lero: A Learning-to-Rank Query Optimizer |
2023 |
VLDB |
7.1908499e-05 |
| 3,455 |
Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation |
2022 |
VLDB |
7.0760196e-05 |
| 3,641 |
OceanBase: A 707 Million tpmC Distributed Relational Database System |
2022 |
VLDB |
6.8877808e-05 |
| 3,729 |
Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection |
2022 |
VLDB |
6.8078013e-05 |
| 4,480 |
Variance Aware Optimization of Parameterized Queries |
2010 |
SIGMOD |
6.1433292e-05 |
| 5,412 |
Kepler: Robust Learning for Faster Parametric Query Optimization |
2023 |
SIGMOD |
5.5200608e-05 |
| 5,476 |
On the Production of Anorexic Plan Diagrams |
2007 |
VLDB |
5.4866057e-05 |
| 6,382 |
Sample-Efficient Cardinality Estimation Using Geometric Deep Learning |
2024 |
VLDB |
5.0835686e-05 |
| 6,471 |
Leveraging Re-costing for Online Optimization of Parameterized Queries with Guarantees |
2017 |
SIGMOD |
5.0438582e-05 |
| 6,639 |
Leveraging Query Logs and Machine Learning for Parametric Query Optimization |
2022 |
VLDB |
4.976781e-05 |
| 7,188 |
LPLM: A Neural Language Model for Cardinality Estimation of LIKE-Queries |
2024 |
SIGMOD |
4.8017628e-05 |
| 7,326 |
Lemo: A Cache-Enhanced Learned Optimizer for Concurrent Queries |
2023 |
SIGMOD |
4.7563708e-05 |
Semantically Similar Papers
| Overall Rank |
Paper |
Year |
Venue |
Pagerank |
| 1,207 |
RankSQL: Query Algebra and Optimization for Relational Top-k Queries |
2005 |
SIGMOD |
0.0001327437 |
| 10,757 |
PAR2QO: Parametric Penalty-Aware Robust Query Optimization |
2025 |
VLDB |
4.1905499e-05 |
| 3,345 |
Lero: A Learning-to-Rank Query Optimizer |
2023 |
VLDB |
7.1908499e-05 |
| 10,050 |
APQO: An Adaptive Framework for Parametric Query Optimization |
2026 |
SIGMOD |
4.1905499e-05 |
| 8,479 |
Can Large Language Models Be Query Optimizer for Relational Databases? |
2026 |
SIGMOD |
4.4967983e-05 |
| 7,009 |
Is Your Learned Query Optimizer Behaving As You Expect? A Machine Learning Perspective |
2024 |
VLDB |
4.8597992e-05 |
| 5,412 |
Kepler: Robust Learning for Faster Parametric Query Optimization |
2023 |
SIGMOD |
5.5200608e-05 |
| 2,249 |
Rank-aware Query Optimization |
2004 |
SIGMOD |
9.1956569e-05 |
| 6,639 |
Leveraging Query Logs and Machine Learning for Parametric Query Optimization |
2022 |
VLDB |
4.976781e-05 |
| 10,219 |
Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking |
2026 |
SIGMOD |
4.1905499e-05 |