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 4 of 4 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 9,756 | APQO: An Adaptive Framework for Parametric Query Optimization | 2026 | SIGMOD | 5.115551e-05 |
| 10,392 | E-LQO: A Comprehensive Energy Evaluation Framework for Learned Query Optimization | 2027 | SIGMOD | 4.9605343e-05 |
| 10,994 | TATA: An Efficient Framework for Task Transfer in Query Plan Representation | 2026 | VLDB | 4.9605343e-05 |
| 11,008 | Towards Industrial-Scale Parametric Query Optimization | 2026 | VLDB | 4.9605343e-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 | 941 | RankSQL: Query Algebra and Optimization for Relational Top-k Queries | 2005 | SIGMOD |
| 2 | 2,190 | Lero: A Learning-to-Rank Query Optimizer | 2023 | VLDB |
| 3 | 9,756 | APQO: An Adaptive Framework for Parametric Query Optimization | 2026 | SIGMOD |
| 4 | 6,584 | Can Large Language Models Be Query Optimizer for Relational Databases? | 2026 | SIGMOD |
| 5 | 6,109 | Is Your Learned Query Optimizer Behaving As You Expect? A Machine Learning Perspective | 2024 | VLDB |
| 6 | 4,202 | Kepler: Robust Learning for Faster Parametric Query Optimization | 2023 | SIGMOD |
| 7 | 1,712 | Rank-aware Query Optimization | 2004 | SIGMOD |
| 8 | 5,062 | Leveraging Query Logs and Machine Learning for Parametric Query Optimization | 2022 | VLDB |
| 9 | 11,008 | Towards Industrial-Scale Parametric Query Optimization | 2026 | VLDB |
| 10 | 10,764 | Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking | 2026 | SIGMOD |