DBScholar

Back to papers

Automatic Indexing in Oracle

Summary: Oracle automates incremental index creation, validation, deployment, and removal—including expression indexes—using isolated evaluation and DML-cost accounting, without a clone. SQL Plan Management contains regressions as workloads evolve; experiments report 15% faster performance and 60% space reclamation. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
14284
Venue
VLDB
Year
2025
Pagerank
5.093636e-05
Overall Rank
11,003 | 24.51%
DOI
10.14778/3750616.3750616

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

BibTeX Citation

@article{chakkappen_vldb25,
        title = {{Automatic Indexing in Oracle}},
        author = {Chakkappen, Sunil and Kunjibettu, Shreya and McGreer, Daniel and Kishi, Masoomeh Javidi and Su, Hong and Ziauddin, Mohamed and Zait, Mohamed and Li, Zhan and Zhang, Yuying},
        journal = {PVLDB},
        series = {{VLDB} '25},
        volume = {18},
        number = {12},
        pages = {4924--4937},
        doi = {10.14778/3750616.3750616},
        url = {https://doi.org/10.14778/3750616.3750616},
        year = {2025}
}

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank Citing Paper Year Venue Pagerank
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 22 of 22 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
87 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00035281619
156 An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server 1997 VLDB 0.00028636811
234 Self-Driving Database Management Systems 2017 CIDR 0.00023810722
259 Database Cracking 2007 CIDR 0.00023119313
387 AutoAdmin "What-if" Index Analysis Utility 1998 SIGMOD 0.00019442332
501 Database Tuning Advisor for Microsoft SQL Server 2005 2004 VLDB 0.0001738508
524 Automatic SQL Tuning in Oracle 10g 2004 VLDB 0.00017120666
1,279 AI Meets AI: Leveraging Query Executions to Improve Index Recommendations 2019 SIGMOD 0.00011361878
1,548 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD 0.00010392475
1,679 Self-organizing Tuple Reconstruction in Column-stores 2009 SIGMOD 0.00010029136
1,811 Merging What's Cracked, Cracking What's Merged: Adaptive Indexing in Main-Memory Column-Stores 2011 VLDB 9.698026e-05
2,378 The Uncracked Pieces in Database Cracking 2014 VLDB 8.6682285e-05
3,558 Updating a Cracked Database 2007 SIGMOD 7.3101789e-05
3,830 Stochastic Database Cracking: Towards Robust Adaptive Indexing in Main-Memory Column-Stores 2012 VLDB 7.0877801e-05
4,039 Semi-Automatic Index Tuning: Keeping DBAs in the Loop 2012 VLDB 6.9424878e-05
4,637 Columnstore and B+ tree – Are Hybrid Physical Designs Important? 2018 SIGMOD 6.592197e-05
4,643 Learned Index Benefits: Machine Learning Based Index Performance Estimation 2022 VLDB 6.5907466e-05
5,039 Holistic Indexing in Main-memory Column-stores 2015 SIGMOD 6.3909067e-05
6,327 Breaking It Down: An In-depth Study of Index Advisors 2024 VLDB 5.9124005e-05
6,651 Progressive Indexes: Indexing for Interactive Data Analysis 2019 VLDB 5.8141997e-05
8,982 Automatic Index Selection for Large-Scale Datalog Computation 2019 VLDB 5.3397715e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 259 Database Cracking 2007 CIDR
2 4,039 Semi-Automatic Index Tuning: Keeping DBAs in the Loop 2012 VLDB
3 9,240 Automatic SQL Error Mitigation in Oracle 2023 VLDB
4 5,039 Holistic Indexing in Main-memory Column-stores 2015 SIGMOD
5 10,413 Understanding and Detecting Query Performance Regression in Practical Index Tuning: [Experiments & Analysis] 2026 SIGMOD
6 4,277 Adaptive Statistics in Oracle 12c 2017 VLDB
7 4,101 Automated Generation of Materialized Views in Oracle 2020 VLDB
8 1,548 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD
9 625 Automatic Performance Diagnosis and Tuning in Oracle 2005 CIDR
10 524 Automatic SQL Tuning in Oracle 10g 2004 VLDB