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.8833461e-05
Overall Rank
6,107 | 58.96%
DOI
10.14778/3675034.3675035
PDF
Download (CC BY-NC-ND 4.0)

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.7133739e-05
8,761 A New Paradigm in Tuning Learned Indexes: A Reinforcement Learning Enhanced Approach 2025 SIGMOD 5.2821881e-05
8,779 Automatic Indexing in Oracle 2025 VLDB 5.2781453e-05
9,635 Low Rank Learning for Offline Query Optimization 2025 SIGMOD 5.1453041e-05
10,428 Automating Database-Native Function Code Synthesis with LLMs 2026 SIGMOD 4.9769913e-05
10,543 Rainbow: Risk-aware Index Benefit Estimation Facing Out Of Distribution Workloads 2026 SIGMOD 4.9769913e-05
10,591 MCTuner: Spatial Decomposition-Enhanced Database Tuning via LLM-Guided Exploration 2026 SIGMOD 4.9769913e-05
10,692 RIB: Robust Learning-based Index Benefit Estimation 2026 SIGMOD 4.9769913e-05
10,726 DBAIOps: A Reasoning LLM-Enhanced Database Operation and Maintenance System using Knowledge Graphs 2026 VLDB 4.9769913e-05
10,927 Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL Server 2026 VLDB 4.9769913e-05
10,949 Bridging NL2SQL for CAN Signal Analytics at NIO: From Externalized Schemas to CTE Pipelines 2026 VLDB 4.9769913e-05
11,232 Esc: An Early-Stopping Checker for Budget-aware Index Tuning 2025 VLDB 4.9769913e-05
13,612 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.00061067652
40 The Case for Learned Index Structures 2018 SIGMOD 0.00046363107
85 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035876108
151 An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server 1997 VLDB 0.00028664776
235 OLTP-Bench: An Extensible Testbed for Benchmarking Relational Databases 2014 VLDB 0.00023689995
462 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.00017836105
751 Automatic Physical Database Tuning: A Relaxation-based Approach 2005 SIGMOD 0.00014251362
981 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.00012713454
1,065 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012202293
1,280 AI Meets AI: Leveraging Query Executions to Improve Index Recommendations 2019 SIGMOD 0.00011224914
1,396 Magic mirror in my hand, which is the best in the land? An Experimental Evaluation of Index Selection Algorithms 2020 VLDB 0.00010788714
1,515 DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems 2021 VLDB 0.00010418766
1,516 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD 0.00010398346
1,815 CoPhy: A Scalable, Portable, and Interactive Index Advisor for Large Workloads 2011 VLDB 9.5756946e-05
2,248 QueryFormer: A Tree Transformer Model for Query Plan Representation 2022 VLDB 8.7567205e-05
2,342 Learned Cardinality Estimation: An In-depth Study 2022 SIGMOD 8.6074783e-05
2,518 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 8.3532841e-05
3,327 Robust Query Driven Cardinality Estimation under Changing Workloads 2023 VLDB 7.4233639e-05
3,680 openGauss: An Autonomous Database System 2021 VLDB 7.1016555e-05
4,058 Semi-Automatic Index Tuning: Keeping DBAs in the Loop 2012 VLDB 6.8230003e-05
4,470 Real-time Workload Pattern Analysis for Large-scale Cloud Databases 2023 VLDB 6.5833414e-05
4,485 LearnedSQLGen: Constraint-aware SQL Generation using Reinforcement Learning 2022 SIGMOD 6.5771335e-05
4,559 Warper: Efficiently Adapting Learned Cardinality Estimators to Data and Workload Drifts 2022 SIGMOD 6.5324275e-05
4,713 Learned Index Benefits: Machine Learning Based Index Performance Estimation 2022 VLDB 6.4543291e-05
4,970 Budget-aware Index Tuning with Reinforcement Learning 2022 SIGMOD 6.3319052e-05
5,632 ISUM: Efficiently Compressing Large and Complex Workloads for Scalable Index Tuning 2022 SIGMOD 6.0554368e-05
6,758 Multi-Tenant Cloud Data Services: State-of-the-Art, Challenges and Opportunities 2022 SIGMOD 5.6877154e-05
7,904 DISTILL: Low-Overhead Data-Driven Techniques for Filtering and Costing Indexes for Scalable Index Tuning 2022 VLDB 5.4277674e-05
8,354 A Comparison of Flexible Schemas for Software as a Service 2009 SIGMOD 5.3472934e-05
8,357 Towards Building Autonomous Data Services on Azure 2023 SIGMOD 5.3463255e-05
9,189 FEBench: A Benchmark for Real-Time Relational Data Feature Extraction 2023 VLDB 5.2097224e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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