关键词: 查询重写, 重写策略, 机器学习, 查询优化

Abstract: The syntax for writing query statements in databases is highly diverse and flexible, with vastly different query formulations possible for the same requirement. The execution performance of queries directly impacts user experience. Query rewriting techniques transform an input query into an equivalent query with superior performance. Given the numerous rewriting rules and complex query environments, designing high-quality query rewriting strategies poses a significant challenge. Traditional query rewriting strategies are either cost-based or heuristic-based; however, achieving optimal query rewriting results in complex query environments remains difficult. With the rise of AI for databases (AI4DB), integrating machine learning methods into query rewriting techniques has become a mainstream approach, enabling further resolution of issues present in traditional query rewriting. Therefore, this paper first elaborates on the relevant technologies, existing problems, and applicable scenarios of traditional query rewriting strategies. Then it introduces machine learning-based query rewriting strategies, with a focus on discussing how they enhance performance. Finally, it discusses the current challenges in query rewriting and offers perspectives on future research directions.

Key words: query rewrite, rewrite strategy, machine learning, query optimization