Institution profile

A.P. Ershov Institute of Informatics Systems

Academic institutioneurope · ru
Official website
Research library2linked papers
Opportunities0open roles
Selected work

Representative Papers

Training-Free Query Optimization via LLM-Based Plan Similarity

Jun 06, 2025

Traditional query optimizers rely on error-prone cost models, while learned optimizers require costly offline training and lack deployment flexibility. Method: We propose a training-free, LLM-embedding-driven execution plan optimization framework. It leverages pre-trained large language models to map SQL queries and their execution plans into a unified embedding space; retrieves semantically similar historical queries via k-nearest-neighbor search; recommends efficient hint sets through majority voting; and ensures robustness via lightweight consistency checking and full-plan-space fallback. Contribution/Results: This is the first work to employ LLM-derived execution plan embeddings for training-free query optimization. It enables end-to-end automatic hint recommendation and achieves deep integration with OpenGauss. Evaluated on the JOB-CEB benchmark, our approach reduces average query latency by 21%, significantly enhancing both practicality and deployment efficiency.

0 citationsRead paper
Recent publications

Latest Papers

Training-Free Query Optimization via LLM-Based Plan Similarity

Jun 06, 2025

Traditional query optimizers rely on error-prone cost models, while learned optimizers require costly offline training and lack deployment flexibility. Method: We propose a training-free, LLM-embedding-driven execution plan optimization framework. It leverages pre-trained large language models to map SQL queries and their execution plans into a unified embedding space; retrieves semantically similar historical queries via k-nearest-neighbor search; recommends efficient hint sets through majority voting; and ensures robustness via lightweight consistency checking and full-plan-space fallback. Contribution/Results: This is the first work to employ LLM-derived execution plan embeddings for training-free query optimization. It enables end-to-end automatic hint recommendation and achieves deep integration with OpenGauss. Evaluated on the JOB-CEB benchmark, our approach reduces average query latency by 21%, significantly enhancing both practicality and deployment efficiency.

0 citationsRead paper