Learned Query Optimizers

B Ding, R Zhu, J Zhou - Foundations and Trends® in …, 2024 - nowpublishers.com
This survey presents recent progress on using machine learning techniques to improve
query optimizers in database systems. Centering around a generic paradigm of learned …

A Novel Technique for Query Plan Representation Based on Graph Neural Nets

B Chang, A Kamali, V Kantere - … Conference on Big Data Analytics and …, 2024 - Springer
Learning representations for query plans play a pivotal role in machine learning-based
query optimizers of database management systems. To this end, particular model …

A Hybrid Cost Model for Evaluating Query Execution Plans

N Wang, A Kamali, V Kantere, C Zuzate… - 2023 IEEE Sixth …, 2023 - ieeexplore.ieee.org
Query optimization aims to select a query execution plan among all query paths for a given
query. The query optimization of traditional relational database management systems …

Efficient Cardinality and Cost Estimation with Bidirectional Compressor-based Ensemble Learning

Z Liang, X Chen, Y Zhao, J **e, K Zeng… - … Conference on Data …, 2023 - ieeexplore.ieee.org
Query optimization is of great importance for the performance of a database, in which
cardinality and cost estimation have a pivotal role. To enable accurate cardinality and cost …

How Good are Learned Cost Models, Really? Insights from Query Optimization Tasks

R Heinrich, M Luthra, J Wehrstein, H Kornmayer… - arxiv preprint arxiv …, 2025 - arxiv.org
Traditionally, query optimizers rely on cost models to choose the best execution plan from
several candidates, making precise cost estimates critical for efficient query execution. In …

Reqo: A Robust and Explainable Query Optimization Cost Model

B Chang, A Kamali, V Kantere - arxiv preprint arxiv:2501.17414, 2025 - arxiv.org
In recent years, there has been a growing interest in using machine learning (ML) in query
optimization to select more efficient plans. Existing learning-based query optimizers use …

A Novel Technique for Query Plan Representation Based on Graph Neural Networks

B Chang, A Kamali, V Kantere - arxiv preprint arxiv:2405.04814, 2024 - arxiv.org
Learning representations for query plans play a pivotal role in machine learning-based
query optimizers of database management systems. To this end, particular model …

Learned Query Optimizer: What is New and What is Next

R Zhu, L Weng, B Ding, J Zhou - Companion of the 2024 International …, 2024 - dl.acm.org
In recent times, learned query optimizer has becoming a hot research topic in learned
databases. It serves as the most suitable experimental plots for utilizing numerous machine …

QCFE: An efficient Feature engineering for query cost estimation

Y Yan, H Wang, J Huang, D Zhong, T Yu… - 2024 IEEE 40th …, 2024 - ieeexplore.ieee.org
Query cost estimation is a classical task for database management. Recently, researchers
have applied AI-driven methods to implement query cost estimation for achieving high …

A Novel Technique for Query Plan Representation Based on Graph Neural

B Chang, A Kamali, V Kantere - Big Data Analytics and …, 2024 - books.google.com
Learning representations for query plans play a pivotal role in machine learning-based
query optimizers of database management sys-tems. To this end, particular model …