EUVIMEDEUVIMED entdecken
Crossref

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

Roman Heinrich, Manisha Luthra, Johannes Wehrstein, Harald Kornmayer, Carsten Binnig

Proceedings of the ACM on Management of Data · 17.06.2025 · 3 (3) · 1-27

DOI: 10.1145/3725309 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Proceedings of the ACM on Management of Data, online erschienen am 18.06.2025. Verfasst von Roman Heinrich und 4 weiteren Autor:innen. Die Arbeit wurde bisher 21-mal zitiert (Crossref) und nennt 47 Literaturangaben. Gefördert von: DFKI, LOEWE, hessian.AI.

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

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 recent years, cost models based on machine learning have been proposed to overcome the weaknesses of traditional cost models. While these models have been shown to provide better prediction accuracy, only limited efforts have been made to investigate how well Learned Cost Models (LCMs) actually perform in query optimization and how they affect overall query performance. In this paper, we address this by a systematic study evaluating LCMs on three of the core query optimization tasks: join ordering, access path selection, and physical operator selection . In our study, we compare seven state-of-the-art LCMs to a traditional cost model and, surprisingly, find that the traditional model often still outperforms LCMs in these tasks. We conclude by highlighting major takeaways and recommendations to guide future research toward making LCMs more effective for query optimization.

Förderung

  • DFKI
  • LOEWE
  • hessian.AI
  • TU Darmstadt
  • DHBW Mannheim

Zitieren

APA

Heinrich, R., Luthra, M., Wehrstein, J., Kornmayer, H., & Binnig, C. (2025). How Good are Learned Cost Models, Really? Insights from Query Optimization Tasks. Proceedings of the ACM on Management of Data, 3(3), 1-27. https://doi.org/10.1145/3725309

Vancouver

Heinrich R, Luthra M, Wehrstein J, Kornmayer H, Binnig C. How Good are Learned Cost Models, Really? Insights from Query Optimization Tasks. Proceedings of the ACM on Management of Data. 2025;3(3):1-27. doi:10.1145/3725309

BibTeX
@article{Heinrich2025,
  author = {Heinrich, Roman and Luthra, Manisha and Wehrstein, Johannes and Kornmayer, Harald and Binnig, Carsten},
  title = {How Good are Learned Cost Models, Really? Insights from Query Optimization Tasks},
  journal = {Proceedings of the ACM on Management of Data},
  year = {2025},
  volume = {3},
  number = {3},
  pages = {1--27},
  doi = {10.1145/3725309}
}
Kostenlos starten →