Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL Server
Proceedings of the VLDB Endowment · 01.08.2026 · 19 (12) · 4049-4062
DOI: 10.14778/3827998.3828015 ↗Kurz gefasst
Fachartikel in der Zeitschrift Proceedings of the VLDB Endowment, online erschienen am 14.09.2026. Verfasst von Xiaoying Wang und 3 weiteren Autor:innen. Die Arbeit wurde bisher 2-mal zitiert (Crossref) und nennt 86 Literaturangaben.
Abstract (Originalsprache)
Indexes are crucial for database performance. Index tuning, i.e., selecting appropriate indexes for a database workload, is an important problem. The state-of-the-art index tuning tools in the industry, e.g., Database Tuning Advisor (DTA) developed for Microsoft SQL Server, rely on a "what-if" API, which can estimate the cost of a query for a given index configuration. They take as input a SQL workload and constraints such as a storage bound, and search over the large space of index configurations to find one with low optimizer-estimated cost for the input workload. Large language models (LLMs) offer a different approach to index tuning, using knowledge they have learned from publicly available training data. However, the effectiveness of LLM-driven index tuning in comparison to today's index advisors, particularly on enterprise workloads, remains unclear. In this paper, we study the practical effectiveness of LLM-driven index tuning on Microsoft SQL Server using both industrial benchmarks and real-world enterprise customer workloads, and compare it with DTA. Our results show that while LLMs in several cases identify configurations that significantly outperform those found by DTA in terms of execution time, they suffer from high variance in index recommendation quality. Furthermore, index recommendations from the LLM are often substantially worse than DTA in terms of optimizer-estimated cost, making it challenging to extend cost-based index advisors such as DTA to leverage LLMs for index tuning. We point to some areas of future work that may be important for robustly leveraging LLMs for index tuning.
Zitieren
APA
Wang, X., Wu, W., Narasayya, V., & Chaudhuri, S. (2026). Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL Server. Proceedings of the VLDB Endowment, 19(12), 4049-4062. https://doi.org/10.14778/3827998.3828015
Vancouver
Wang X, Wu W, Narasayya V, Chaudhuri S. Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL Server. Proceedings of the VLDB Endowment. 2026;19(12):4049-4062. doi:10.14778/3827998.3828015
BibTeX
@article{Wang2026,
author = {Wang, Xiaoying and Wu, Wentao and Narasayya, Vivek and Chaudhuri, Surajit},
title = {Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL Server},
journal = {Proceedings of the VLDB Endowment},
year = {2026},
volume = {19},
number = {12},
pages = {4049--4062},
doi = {10.14778/3827998.3828015}
}
EUVIMED