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
- 14243
- Venue
- VLDB
- Year
- 2025
- Pagerank
- 4.1945683e-05
- Overall Rank
- 10,880 | 24.31%
- 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.00059038975 |
| 333 |
Neo: A Learned Query Optimizer |
2019 |
VLDB |
0.00027206884 |
| 640 |
Bao: Making Learned Query Optimization Practical |
2021 |
SIGMOD |
0.00018759152 |
| 806 |
An End-to-End Learning-based Cost Estimator |
2020 |
VLDB |
0.00016434274 |
| 1,070 |
Analyzing Plan Diagrams of Database Query Optimizers |
2005 |
VLDB |
0.00014316791 |
| 1,638 |
Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation |
2022 |
VLDB |
0.00011049779 |
| 1,647 |
Parametric Query Optimization for Linear and Piecewise Linear Cost Functions |
2002 |
VLDB |
0.00011033757 |
| 1,726 |
Design and Analysis of Parametric Query Optimization Algorithms |
1998 |
VLDB |
0.00010741411 |
| 1,986 |
AniPQO: Almost Non-intrusive Parametric Query Optimization for Nonlinear Cost Functions |
2003 |
VLDB |
9.8536784e-05 |
| 2,121 |
Balsa: Learning a Query Optimizer Without Expert Demonstrations |
2022 |
SIGMOD |
9.5017232e-05 |
| 2,985 |
DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems |
2021 |
VLDB |
7.7795847e-05 |
| 3,169 |
QueryFormer: A Tree Transformer Model for Query Plan Representation |
2022 |
VLDB |
7.4498425e-05 |
| 3,266 |
Learned Cardinality Estimation: An In-depth Study |
2022 |
SIGMOD |
7.3074684e-05 |
| 3,348 |
Lero: A Learning-to-Rank Query Optimizer |
2023 |
VLDB |
7.1904529e-05 |
| 3,449 |
Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation |
2022 |
VLDB |
7.0824319e-05 |
| 3,628 |
OceanBase: A 707 Million tpmC Distributed Relational Database System |
2022 |
VLDB |
6.9031596e-05 |
| 3,727 |
Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection |
2022 |
VLDB |
6.8141709e-05 |
| 4,482 |
Variance Aware Optimization of Parameterized Queries |
2010 |
SIGMOD |
6.1482936e-05 |
| 5,423 |
Kepler: Robust Learning for Faster Parametric Query Optimization |
2023 |
SIGMOD |
5.5130233e-05 |
| 5,466 |
On the Production of Anorexic Plan Diagrams |
2007 |
VLDB |
5.4909203e-05 |
| 6,383 |
Sample-Efficient Cardinality Estimation Using Geometric Deep Learning |
2024 |
VLDB |
5.0884322e-05 |
| 6,479 |
Leveraging Re-costing for Online Optimization of Parameterized Queries with Guarantees |
2017 |
SIGMOD |
5.0483805e-05 |
| 6,667 |
Leveraging Query Logs and Machine Learning for Parametric Query Optimization |
2022 |
VLDB |
4.9688874e-05 |
| 7,186 |
LPLM: A Neural Language Model for Cardinality Estimation of LIKE-Queries |
2024 |
SIGMOD |
4.8063731e-05 |
| 7,330 |
Lemo: A Cache-Enhanced Learned Optimizer for Concurrent Queries |
2023 |
SIGMOD |
4.7609373e-05 |
Semantically Similar Papers
| Overall Rank |
Paper |
Year |
Venue |
Pagerank |
| 10,751 |
PAR2QO: Parametric Penalty-Aware Robust Query Optimization |
2025 |
VLDB |
4.1945683e-05 |
| 1,262 |
RankSQL: Query Algebra and Optimization for Relational Top-k Queries |
2005 |
SIGMOD |
0.00012986539 |
| 3,348 |
Lero: A Learning-to-Rank Query Optimizer |
2023 |
VLDB |
7.1904529e-05 |
| 10,050 |
APQO: An Adaptive Framework for Parametric Query Optimization |
2026 |
SIGMOD |
4.1945683e-05 |
| 8,488 |
Can Large Language Models Be Query Optimizer for Relational Databases? |
2026 |
SIGMOD |
4.4998609e-05 |
| 7,008 |
Is Your Learned Query Optimizer Behaving As You Expect? A Machine Learning Perspective |
2024 |
VLDB |
4.8643538e-05 |
| 5,423 |
Kepler: Robust Learning for Faster Parametric Query Optimization |
2023 |
SIGMOD |
5.5130233e-05 |
| 2,393 |
Rank-aware Query Optimization |
2004 |
SIGMOD |
8.9016542e-05 |
| 6,667 |
Leveraging Query Logs and Machine Learning for Parametric Query Optimization |
2022 |
VLDB |
4.9688874e-05 |
| 10,219 |
Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking |
2026 |
SIGMOD |
4.1945683e-05 |