{"id":"https://openalex.org/W7134917777","doi":"https://doi.org/10.48550/arxiv.2603.09181","title":"Evaluating the Practical Effectiveness of LLM-Driven Index Tuning with Microsoft Database Tuning Advisor","display_name":"Evaluating the Practical Effectiveness of LLM-Driven Index Tuning with Microsoft Database Tuning Advisor","publication_year":2026,"publication_date":"2026-03-10","ids":{"openalex":"https://openalex.org/W7134917777","doi":"https://doi.org/10.48550/arxiv.2603.09181"},"language":null,"primary_location":{"id":"doi:10.48550/arxiv.2603.09181","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2603.09181","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"},"type":"preprint","indexed_in":["datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.48550/arxiv.2603.09181","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5128757989","display_name":"Xiaoying Wang","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Wang, Xiaoying","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5128735201","display_name":"Wentao Wu","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Wu, Wentao","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5063257827","display_name":"Vivek Narasayya","orcid":"https://orcid.org/0000-0001-7011-7886"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Narasayya, Vivek","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5038037154","display_name":"Surajit Chaudhuri","orcid":"https://orcid.org/0000-0001-8252-5270"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Chaudhuri, Surajit","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5128757989"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.25780001282691956,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.25780001282691956,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.10509999841451645,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10286","display_name":"Information Retrieval and Search Behavior","score":0.09229999780654907,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/index","display_name":"Index (typography)","score":0.7912999987602234},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.4810999929904938},{"id":"https://openalex.org/keywords/performance-tuning","display_name":"Performance tuning","score":0.4447999894618988},{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.4097000062465668},{"id":"https://openalex.org/keywords/work","display_name":"Work (physics)","score":0.4009999930858612},{"id":"https://openalex.org/keywords/microsoft-excel","display_name":"Microsoft excel","score":0.3695000112056732}],"concepts":[{"id":"https://openalex.org/C2777382242","wikidata":"https://www.wikidata.org/wiki/Q6017816","display_name":"Index (typography)","level":2,"score":0.7912999987602234},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7670999765396118},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5163999795913696},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4810999929904938},{"id":"https://openalex.org/C2777138346","wikidata":"https://www.wikidata.org/wiki/Q1714153","display_name":"Performance tuning","level":2,"score":0.4447999894618988},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.4097000062465668},{"id":"https://openalex.org/C18762648","wikidata":"https://www.wikidata.org/wiki/Q42213","display_name":"Work (physics)","level":2,"score":0.4009999930858612},{"id":"https://openalex.org/C3019730874","wikidata":"https://www.wikidata.org/wiki/Q11272","display_name":"Microsoft excel","level":2,"score":0.3695000112056732},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.32910001277923584},{"id":"https://openalex.org/C2778348673","wikidata":"https://www.wikidata.org/wiki/Q739302","display_name":"Production (economics)","level":2,"score":0.3206000030040741},{"id":"https://openalex.org/C59276292","wikidata":"https://www.wikidata.org/wiki/Q580427","display_name":"Database index","level":3,"score":0.2973000109195709},{"id":"https://openalex.org/C13736549","wikidata":"https://www.wikidata.org/wiki/Q4489420","display_name":"Industrial engineering","level":1,"score":0.28119999170303345},{"id":"https://openalex.org/C107535962","wikidata":"https://www.wikidata.org/wiki/Q2459880","display_name":"Database tuning","level":4,"score":0.27309998869895935},{"id":"https://openalex.org/C174634509","wikidata":"https://www.wikidata.org/wiki/Q4200716","display_name":"Industrial production index","level":3,"score":0.26910001039505005},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.26820001006126404},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.2500999867916107}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.48550/arxiv.2603.09181","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2603.09181","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":{"id":"doi:10.48550/arxiv.2603.09181","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2603.09181","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"},"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","score":0.6461073756217957,"id":"https://metadata.un.org/sdg/9"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"Index":[0],"tuning":[1,106,183,227],"is":[2,86,127],"critical":[3],"for":[4,22],"the":[5,16,28,33,38,54,77,100,205],"performance":[6,192,209],"of":[7,40,79,103,153,208],"modern":[8],"database":[9],"systems.":[10],"Industrial":[11],"index":[12,45,67,81,91,105,182,226],"tuners,":[13,92],"such":[14],"as":[15,158],"Database":[17],"Tuning":[18],"Advisor":[19],"(DTA)":[20],"developed":[21],"Microsoft":[23],"SQL":[24],"Server,":[25],"rely":[26],"on":[27,224],"\"what-if\"":[29],"API":[30],"provided":[31],"by":[32,89,144],"query":[34,42],"optimizer":[35],"to":[36,50,66,175,189],"estimate":[37],"cost":[39,207],"a":[41,63,132,150,159],"given":[43],"an":[44],"configuration,":[46],"which":[47],"can":[48,136],"lead":[49],"suboptimal":[51],"recommendations":[52],"when":[53,199],"estimations":[55],"are":[56],"inaccurate.":[57],"Large":[58],"language":[59],"model":[60],"(LLM)":[61],"offers":[62],"new":[64],"approach":[65],"tuning,":[68,82],"with":[69,119,131],"knowledge":[70],"learned":[71],"from":[72],"web-scale":[73],"training":[74],"datasets.":[75],"However,":[76,179],"effectiveness":[78,102],"LLM-driven":[80,104,181,225],"especially":[83],"beyond":[84],"what":[85],"already":[87],"achieved":[88],"commercial":[90],"remains":[93,186],"unclear.":[94],"In":[95],"this":[96],"paper,":[97],"we":[98],"study":[99],"practical":[101,217],"using":[107],"both":[108,228],"industrial":[109],"benchmarks":[110],"and":[111,116,195,204,216,231],"real-world":[112],"enterprise":[113],"customer":[114],"workloads,":[115],"compare":[117],"it":[118],"DTA.":[120,178],"Our":[121],"results":[122],"show":[123],"that":[124,139,165,171,219],"although":[125],"DTA":[126,145],"generally":[128],"more":[129],"reliable,":[130],"few":[133],"invocations,":[134],"LLM":[135],"identify":[137],"configurations":[138],"significantly":[140],"outperform":[141],"those":[142],"found":[143],"in":[146,149,184,229],"execution":[147],"time":[148],"considerable":[151],"number":[152],"cases,":[154],"highlighting":[155],"its":[156,190],"potential":[157],"complementary":[160],"technique.":[161],"We":[162],"also":[163],"observe":[164],"LLM's":[166],"reasoning":[167],"captures":[168],"human-intuitive":[169],"insights":[170,218],"may":[172],"be":[173],"distilled":[174],"potentially":[176],"improve":[177],"adopting":[180],"production":[185],"challenging":[187],"due":[188],"substantial":[191],"variance,":[193],"limited":[194],"often":[196],"negative":[197],"impact":[198],"directly":[200],"integrated":[201],"into":[202],"DTA,":[203],"high":[206],"validation.":[210],"This":[211],"work":[212,223],"provides":[213],"motivation,":[214],"lessons,":[215],"will":[220],"inspire":[221],"future":[222],"academia":[230],"industry.":[232]},"counts_by_year":[],"updated_date":"2026-05-05T08:41:31.759640","created_date":"2026-03-12T00:00:00"}