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
13655
Venue
VLDB
Year
2024
Pagerank
5.9124005e-05
Overall Rank
6,327 | 56.60%
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 10 of 10 citing papers.

Rank Citing Paper Year Venue Pagerank
8,423 Cracking SQL Barriers: An LLM-based Dialect Translation System 2025 SIGMOD 5.4275169e-05
8,591 A New Paradigm in Tuning Learned Indexes: A Reinforcement Learning Enhanced Approach 2025 SIGMOD 5.4059856e-05
9,601 Low Rank Learning for Offline Query Optimization 2025 SIGMOD 5.2487799e-05
10,200 Automating Database-Native Function Code Synthesis with LLMs 2026 SIGMOD 5.093636e-05
10,327 Rainbow: Risk-aware Index Benefit Estimation Facing Out Of Distribution Workloads 2026 SIGMOD 5.093636e-05
10,384 MCTuner: Spatial Decomposition-Enhanced Database Tuning via LLM-Guided Exploration 2026 SIGMOD 5.093636e-05
10,494 RIB: Robust Learning-based Index Benefit Estimation 2026 SIGMOD 5.093636e-05
10,532 DBAIOps: A Reasoning LLM-Enhanced Database Operation and Maintenance System using Knowledge Graphs 2026 VLDB 5.093636e-05
10,815 Esc: An Early-Stopping Checker for Budget-aware Index Tuning 2025 VLDB 5.093636e-05
11,003 Automatic Indexing in Oracle 2025 VLDB 5.093636e-05
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
18 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059284255
43 The Case for Learned Index Structures 2018 SIGMOD 0.00046060254
84 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035838391
156 An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server 1997 VLDB 0.00028636811
226 OLTP-Bench: An Extensible Testbed for Benchmarking Relational Databases 2014 VLDB 0.00024027277
465 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.0001803934
768 Automatic Physical Database Tuning: A Relaxation-based Approach 2005 SIGMOD 0.00014173242
1,061 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012369764
1,122 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.0001209124
1,279 AI Meets AI: Leveraging Query Executions to Improve Index Recommendations 2019 SIGMOD 0.00011361878
1,481 Magic mirror in my hand, which is the best in the land? An Experimental Evaluation of Index Selection Algorithms 2020 VLDB 0.00010644613
1,548 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD 0.00010392475
1,832 DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems 2021 VLDB 9.6607418e-05
1,904 CoPhy: A Scalable, Portable, and Interactive Index Advisor for Large Workloads 2011 VLDB 9.5040429e-05
2,355 QueryFormer: A Tree Transformer Model for Query Plan Representation 2022 VLDB 8.7022189e-05
2,543 Learned Cardinality Estimation: An In-depth Study 2022 SIGMOD 8.4445934e-05
2,723 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 8.2049453e-05
3,338 Robust Query Driven Cardinality Estimation under Changing Workloads 2023 VLDB 7.5068221e-05
3,662 openGauss: An Autonomous Database System 2021 VLDB 7.2166682e-05
4,039 Semi-Automatic Index Tuning: Keeping DBAs in the Loop 2012 VLDB 6.9424878e-05
4,398 Real-time Workload Pattern Analysis for Large-scale Cloud Databases 2023 VLDB 6.7248611e-05
4,612 Warper: Efficiently Adapting Learned Cardinality Estimators to Data and Workload Drifts 2022 SIGMOD 6.6072026e-05
4,643 Learned Index Benefits: Machine Learning Based Index Performance Estimation 2022 VLDB 6.5907466e-05
5,091 Budget-aware Index Tuning with Reinforcement Learning 2022 SIGMOD 6.3669569e-05
5,169 LearnedSQLGen: Constraint-aware SQL Generation using Reinforcement Learning 2022 SIGMOD 6.3349035e-05
5,869 ISUM: Efficiently Compressing Large and Complex Workloads for Scalable Index Tuning 2022 SIGMOD 6.0610922e-05
6,939 Multi-Tenant Cloud Data Services: State-of-the-Art, Challenges and Opportunities 2022 SIGMOD 5.7338637e-05
7,750 DISTILL: Low-Overhead Data-Driven Techniques for Filtering and Costing Indexes for Scalable Index Tuning 2022 VLDB 5.5523652e-05
8,186 A Comparison of Flexible Schemas for Software as a Service 2009 SIGMOD 5.4705133e-05
8,193 Towards Building Autonomous Data Services on Azure 2023 SIGMOD 5.4696038e-05
9,433 FEBench: A Benchmark for Real-Time Relational Data Feature Extraction 2023 VLDB 5.2696166e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 847 Benchmarking Learned Indexes 2021 VLDB
2 1,512 On the Analysis of Indexing Schemes 1997 PODS
3 1,481 Magic mirror in my hand, which is the best in the land? An Experimental Evaluation of Index Selection Algorithms 2020 VLDB
4 5,091 Budget-aware Index Tuning with Reinforcement Learning 2022 SIGMOD
5 11,306 Looking Deeply into the Magic Mirror: An Interactive Analysis of Database Index Selection Approaches 2024 VLDB
6 2,806 Are Updatable Learned Indexes Ready? 2022 VLDB
7 8,076 Leveraging Dynamic and Heterogeneous Workload Knowledge to Boost the Performance of Index Advisors 2024 VLDB
8 10,984 Benchmarking Adaptive Multidimensional Indices 2025 VLDB
9 3,792 Learned Index: A Comprehensive Experimental Evaluation 2023 VLDB
10 4,643 Learned Index Benefits: Machine Learning Based Index Performance Estimation 2022 VLDB