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)
Incoming Non-self Citations Over Time
No non-self incoming citations found for this paper in this database.
Authors
- 1. Songsong Mo (Nanyang Technological University)
- 2. Yue Zhao (Nanyang Technological University)
- 3. Zhifeng Bao (RMIT University)
- 4. Quanqing Xu (OceanBase, Ant Group)
- 5. Chuanhui Yang (OceanBase, Ant Group)
- 6. Gao Cong (Nanyang Technological University)
BibTeX Citation
@article{mo_vldb25,
title = {{RankPQO: Learning-to-Rank for Parametric Query Optimization}},
author = {Mo, Songsong and Zhao, Yue and Bao, Zhifeng and Xu, Quanqing and Yang, Chuanhui and Cong, Gao},
journal = {PVLDB},
series = {{VLDB} '25},
volume = {18},
number = {3},
pages = {863--875},
doi = {10.14778/3712221.3712248},
url = {https://doi.org/10.14778/3712221.3712248},
year = {2025}
}Incoming Citations (Sorted by Pagerank)
Showing 2 of 2 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 10,343 | APQO: An Adaptive Framework for Parametric Query Optimization | 2026 | SIGMOD | 5.093636e-05 |
| 10,586 | TATA: An Efficient Framework for Task Transfer in Query Plan Representation | 2026 | VLDB | 5.093636e-05 |
Previous
Page 1 / 1
Next
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.
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 10,986 | PAR2QO: Parametric Penalty-Aware Robust Query Optimization | 2025 | VLDB |
| 2 | 973 | RankSQL: Query Algebra and Optimization for Relational Top-k Queries | 2005 | SIGMOD |
| 3 | 2,420 | Lero: A Learning-to-Rank Query Optimizer | 2023 | VLDB |
| 4 | 10,343 | APQO: An Adaptive Framework for Parametric Query Optimization | 2026 | SIGMOD |
| 5 | 7,809 | Can Large Language Models Be Query Optimizer for Relational Databases? | 2026 | SIGMOD |
| 6 | 6,271 | Is Your Learned Query Optimizer Behaving As You Expect? A Machine Learning Perspective | 2024 | VLDB |
| 7 | 4,470 | Kepler: Robust Learning for Faster Parametric Query Optimization | 2023 | SIGMOD |
| 8 | 1,759 | Rank-aware Query Optimization | 2004 | SIGMOD |
| 9 | 5,394 | Leveraging Query Logs and Machine Learning for Parametric Query Optimization | 2022 | VLDB |
| 10 | 10,508 | Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking | 2026 | SIGMOD |