DBScholar

Back to papers

Breaking It Down: An In-depth Study of Index Advisors

Summary: Systematically decomposes index advisors into three workflow blocks, taxonomy, and evaluates 17 methods across 11 datasets/systems. An open-source testbed, ablations, and explainable ML expose robustness, scenario fit, and key performance drivers. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
hcea518a28a8d6bb9
Venue
VLDB
Year
2024
Pagerank
5.8860941e-05
Overall Rank
6,105 | 58.96%
DOI
10.14778/3675034.3675035

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{zhou_vldb24,
        title = {{Breaking It Down: An In-depth Study of Index Advisors}},
        author = {Zhou, Wei and Lin, Chen and Zhou, Xuanhe and Li, Guoliang},
        journal = {PVLDB},
        series = {{VLDB} '24},
        volume = {17},
        number = {10},
        pages = {2405--2418},
        doi = {10.14778/3675034.3675035},
        url = {https://doi.org/10.14778/3675034.3675035},
        year = {2024}
}

Incoming Citations (Sorted by Pagerank)

Showing 13 of 13 citing papers.

Rank Citing Paper Year Venue Pagerank
4,229 Cracking SQL Barriers: An LLM-based Dialect Translation System 2025 SIGMOD 6.7165534e-05
8,753 A New Paradigm in Tuning Learned Indexes: A Reinforcement Learning Enhanced Approach 2025 SIGMOD 5.2846898e-05
8,771 Automatic Indexing in Oracle 2025 VLDB 5.2806451e-05
9,670 Low Rank Learning for Offline Query Optimization 2025 SIGMOD 5.1452097e-05
10,416 Automating Database-Native Function Code Synthesis with LLMs 2026 SIGMOD 4.9793485e-05
10,532 Rainbow: Risk-aware Index Benefit Estimation Facing Out Of Distribution Workloads 2026 SIGMOD 4.9793485e-05
10,580 MCTuner: Spatial Decomposition-Enhanced Database Tuning via LLM-Guided Exploration 2026 SIGMOD 4.9793485e-05
10,681 RIB: Robust Learning-based Index Benefit Estimation 2026 SIGMOD 4.9793485e-05
10,716 DBAIOps: A Reasoning LLM-Enhanced Database Operation and Maintenance System using Knowledge Graphs 2026 VLDB 4.9793485e-05
10,918 Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL Server 2026 VLDB 4.9793485e-05
10,940 Bridging NL2SQL for CAN Signal Analytics at NIO: From Externalized Schemas to CTE Pipelines 2026 VLDB 4.9793485e-05
11,224 Esc: An Early-Stopping Checker for Budget-aware Index Tuning 2025 VLDB 4.9793485e-05
13,606 DBCooker: A Database Kernel-Specialized Coding Agent Harness 2026 VLDB -
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 31 of 31 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061066921
40 The Case for Learned Index Structures 2018 SIGMOD 0.00046284649
85 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035864347
151 An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server 1997 VLDB 0.00028672526
235 OLTP-Bench: An Extensible Testbed for Benchmarking Relational Databases 2014 VLDB 0.00023697028
461 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.00017829982
751 Automatic Physical Database Tuning: A Relaxation-based Approach 2005 SIGMOD 0.0001425375
982 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.00012714044
1,064 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012202282
1,279 AI Meets AI: Leveraging Query Executions to Improve Index Recommendations 2019 SIGMOD 0.00011226878
1,397 Magic mirror in my hand, which is the best in the land? An Experimental Evaluation of Index Selection Algorithms 2020 VLDB 0.00010789242
1,515 DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems 2021 VLDB 0.00010417728
1,516 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD 0.00010402594
1,815 CoPhy: A Scalable, Portable, and Interactive Index Advisor for Large Workloads 2011 VLDB 9.5791737e-05
2,250 QueryFormer: A Tree Transformer Model for Query Plan Representation 2022 VLDB 8.7533306e-05
2,342 Learned Cardinality Estimation: An In-depth Study 2022 SIGMOD 8.6060437e-05
2,522 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 8.3477168e-05
3,327 Robust Query Driven Cardinality Estimation under Changing Workloads 2023 VLDB 7.4207879e-05
3,682 openGauss: An Autonomous Database System 2021 VLDB 7.1013922e-05
4,058 Semi-Automatic Index Tuning: Keeping DBAs in the Loop 2012 VLDB 6.8257215e-05
4,468 Real-time Workload Pattern Analysis for Large-scale Cloud Databases 2023 VLDB 6.5863349e-05
4,482 LearnedSQLGen: Constraint-aware SQL Generation using Reinforcement Learning 2022 SIGMOD 6.5802486e-05
4,563 Warper: Efficiently Adapting Learned Cardinality Estimators to Data and Workload Drifts 2022 SIGMOD 6.5320994e-05
4,711 Learned Index Benefits: Machine Learning Based Index Performance Estimation 2022 VLDB 6.4573842e-05
4,968 Budget-aware Index Tuning with Reinforcement Learning 2022 SIGMOD 6.3348803e-05
5,630 ISUM: Efficiently Compressing Large and Complex Workloads for Scalable Index Tuning 2022 SIGMOD 6.0582762e-05
6,753 Multi-Tenant Cloud Data Services: State-of-the-Art, Challenges and Opportunities 2022 SIGMOD 5.6904085e-05
7,900 DISTILL: Low-Overhead Data-Driven Techniques for Filtering and Costing Indexes for Scalable Index Tuning 2022 VLDB 5.4303143e-05
8,350 A Comparison of Flexible Schemas for Software as a Service 2009 SIGMOD 5.3498251e-05
8,352 Towards Building Autonomous Data Services on Azure 2023 SIGMOD 5.3488341e-05
9,179 FEBench: A Benchmark for Real-Time Relational Data Feature Extraction 2023 VLDB 5.2121898e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 1,527 On the Analysis of Indexing Schemes 1997 PODS
2 1,397 Magic mirror in my hand, which is the best in the land? An Experimental Evaluation of Index Selection Algorithms 2020 VLDB
3 4,968 Budget-aware Index Tuning with Reinforcement Learning 2022 SIGMOD
4 10,918 Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL Server 2026 VLDB
5 11,625 Looking Deeply into the Magic Mirror: An Interactive Analysis of Database Index Selection Approaches 2024 VLDB
6 2,636 Are Updatable Learned Indexes Ready? 2022 VLDB
7 7,968 Leveraging Dynamic and Heterogeneous Workload Knowledge to Boost the Performance of Index Advisors 2024 VLDB
8 11,365 Benchmarking Adaptive Multidimensional Indices 2025 VLDB
9 3,697 Learned Index: A Comprehensive Experimental Evaluation 2023 VLDB
10 4,711 Learned Index Benefits: Machine Learning Based Index Performance Estimation 2022 VLDB