<abstract xmlns="http://www.w3.org/1999/xhtml">

<p>Recently, numerous machine learning (ML) techniques have been applied to address database performance management problems, including cardinality estimation, cost modeling, optimal join order prediction, hint generation, etc. In this paper, we focus on query optimizer hints employed by users in their queries in order to mask some Query Optimizer deficiencies. We treat the query optimizer hints, bound to previous queries, as significant additional query metadata and learn to automatically predict which new queries will pose similar performance challenges and should therefore also be supported by query optimizer hints. To validate our approach, we have performed a number of experiments using real-life SQL workloads and we achieved promising results.</p>
</abstract>

Recently, numerous machine learning (ML) techniques have been applied to address database performance management problems, including cardinality estimation, cost modeling, optimal join order prediction, hint generation, etc. In this paper, we focus on query optimizer hints employed by users in their queries in order to mask some Query Optimizer deficiencies. We treat the query optimizer hints, bound to previous queries, as significant additional query metadata and learn to automatically predict which new queries will pose similar performance challenges and should therefore also be supported by query optimizer hints. To validate our approach, we have performed a number of experiments using real-life SQL workloads and we achieved promising results.

Learning From User-Specified Optimizer Hints in Database Systems

Foundations of Computing and Decision Sciences

This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 3.0 License.

{"article-title":"Learning From User-Specified Optimizer Hints in Database Systems"}

Recently, numerous machine learning (ML) techniques have been applied to address database performance management problems, including cardinality estimation,...

Learning From User-Specified Optimizer Hints in Database Systems

Data publikacji: 26 maj 2024

Zakres stron: 181 - 197

Otrzymano: 19 paź 2023

Przyjęty: 15 lut 2024

DOI: https://doi.org/10.2478/fcds-2024-0011

Słowa kluczowe
database systems, query optimization

© 2024 Maciej Zakrzewicz, published by Sciendo

This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 3.0 License.

Learning From User-Specified Optimizer Hints in Database Systems

Data publikacji: 26 maj 2024

Zakres stron: 181 - 197

Otrzymano: 19 paź 2023

Przyjęty: 15 lut 2024

DOI: https://doi.org/10.2478/fcds-2024-0011

Słowa kluczowedatabase systems, query optimization

© 2024 Maciej Zakrzewicz, published by Sciendo

This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 3.0 License.

Słowa kluczowe
database systems, query optimization