DBScholar

Back to papers

Refactoring Index Tuning Process with Benefit Estimation

Summary: RIBE refactors index tuning by removing redundant workload queries and using plan statistics with an attention-based model to estimate index benefits. It skips costly what-if calls without DBMS changes, delivering 1–2 orders of magnitude speedups and better tuning quality. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
hdac866b4c342b6ad
Venue
VLDB
Year
2024
Pagerank
5.5808392e-05
Overall Rank
7,219 | 51.49%
DOI
10.14778/3654621.3654622
PDF
Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{yu_vldb24,
        title = {{Refactoring Index Tuning Process with Benefit Estimation}},
        author = {Yu, Tao and Zou, Zhaonian and Sun, Weihua and Yan, Yu},
        journal = {PVLDB},
        series = {{VLDB} '24},
        volume = {17},
        number = {7},
        pages = {1528--1541},
        doi = {10.14778/3654621.3654622},
        url = {https://doi.org/10.14778/3654621.3654622},
        year = {2024}
}

Incoming Citations (Sorted by Pagerank)

Showing 5 of 5 citing papers.

Rank Citing Paper Year Venue Pagerank
9,614 TxnSails: Achieving Serializable Transaction Scheduling with Self-Adaptive Isolation Level Selection 2025 VLDB 5.1506861e-05
10,543 Rainbow: Risk-aware Index Benefit Estimation Facing Out Of Distribution Workloads 2026 SIGMOD 4.9769913e-05
10,692 RIB: Robust Learning-based Index Benefit Estimation 2026 SIGMOD 4.9769913e-05
11,201 PLM4NDV: Minimizing Data Access for Number of Distinct Values Estimation with Pre-trained Language Models 2025 SIGMOD 4.9769913e-05
11,232 Esc: An Early-Stopping Checker for Budget-aware Index Tuning 2025 VLDB 4.9769913e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 25 of 25 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
144 Neo: A Learned Query Optimizer 2019 VLDB 0.00029090793
151 An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server 1997 VLDB 0.00028664776
318 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00021166957
361 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00020000855
378 AutoAdmin "What-if" Index Analysis Utility 1998 SIGMOD 0.00019541534
462 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.00017836105
510 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017059914
560 Plan-Structured Deep Neural Network Models for Query Performance Prediction 2019 VLDB 0.00016408613
751 Automatic Physical Database Tuning: A Relaxation-based Approach 2005 SIGMOD 0.00014251362
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,815 CoPhy: A Scalable, Portable, and Interactive Index Advisor for Large Workloads 2011 VLDB 9.5756946e-05
2,002 FLAT: Fast, Lightweight and Accurate Method for Cardinality Estimation 2021 VLDB 9.2076835e-05
2,248 QueryFormer: A Tree Transformer Model for Query Plan Representation 2022 VLDB 8.7567205e-05
2,837 Query Performance Prediction for Concurrent Queries using Graph Embedding 2020 VLDB 7.9495917e-05
3,327 Robust Query Driven Cardinality Estimation under Changing Workloads 2023 VLDB 7.4233639e-05
3,809 Comprehensive and Efficient Workload Compression 2021 VLDB 7.0064875e-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
5,675 HMAB: Self-Driving Hierarchy of Bandits for Integrated Physical Database Design Tuning 2023 VLDB 6.0401656e-05
7,904 DISTILL: Low-Overhead Data-Driven Techniques for Filtering and Costing Indexes for Scalable Index Tuning 2022 VLDB 5.4277674e-05
9,649 CEDA: Learned Cardinality Estimation with Domain Adaptation 2023 VLDB 5.143243e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 7,904 DISTILL: Low-Overhead Data-Driven Techniques for Filtering and Costing Indexes for Scalable Index Tuning 2022 VLDB
2 3,621 Learned Index: A Comprehensive Experimental Evaluation 2023 VLDB
3 10,543 Rainbow: Risk-aware Index Benefit Estimation Facing Out Of Distribution Workloads 2026 SIGMOD
4 11,631 Looking Deeply into the Magic Mirror: An Interactive Analysis of Database Index Selection Approaches 2024 VLDB
5 10,615 Understanding and Detecting Query Performance Regression in Practical Index Tuning: [Experiments & Analysis] 2026 SIGMOD
6 10,927 Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL Server 2026 VLDB
7 1,280 AI Meets AI: Leveraging Query Executions to Improve Index Recommendations 2019 SIGMOD
8 4,970 Budget-aware Index Tuning with Reinforcement Learning 2022 SIGMOD
9 4,713 Learned Index Benefits: Machine Learning Based Index Performance Estimation 2022 VLDB
10 10,692 RIB: Robust Learning-based Index Benefit Estimation 2026 SIGMOD