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
h41908a45a762a64c
Venue
VLDB
Year
2025
Pagerank
5.2781453e-05
Overall Rank
8,779 | 41.00%
DOI
10.14778/3750616.3750616
PDF
Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

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 4 of 4 citing papers.

Rank Citing Paper Year Venue Pagerank
10,842 ReSequel: Robust LLM-assisted Query Rewriting and Optimization using Templatization and Sampling 2026 VLDB 4.9769913e-05
10,925 AutoLiquid: Autonomic Data Layout Optimization for the Databricks Lakehouse 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,937 Real-time SQL Plan Management in Oracle 2026 VLDB 4.9769913e-05
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
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061067652
88 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00035340164
151 An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server 1997 VLDB 0.00028664776
224 Self-Driving Database Management Systems 2017 CIDR 0.00024011047
252 Database Cracking 2007 CIDR 0.00023101361
378 AutoAdmin "What-if" Index Analysis Utility 1998 SIGMOD 0.00019541534
492 Database Tuning Advisor for Microsoft SQL Server 2005 2004 VLDB 0.00017406029
529 Automatic SQL Tuning in Oracle 10g 2004 VLDB 0.00016859276
1,280 AI Meets AI: Leveraging Query Executions to Improve Index Recommendations 2019 SIGMOD 0.00011224914
1,516 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD 0.00010398346
1,693 Self-organizing Tuple Reconstruction in Column-stores 2009 SIGMOD 9.8522869e-05
1,837 Merging What's Cracked, Cracking What's Merged: Adaptive Indexing in Main-Memory Column-Stores 2011 VLDB 9.5315292e-05
2,384 The Uncracked Pieces in Database Cracking 2014 VLDB 8.5401256e-05
3,606 Updating a Cracked Database 2007 SIGMOD 7.1653182e-05
3,879 Stochastic Database Cracking: Towards Robust Adaptive Indexing in Main-Memory Column-Stores 2012 VLDB 6.9481594e-05
4,058 Semi-Automatic Index Tuning: Keeping DBAs in the Loop 2012 VLDB 6.8230003e-05
4,692 Columnstore and B+ tree – Are Hybrid Physical Designs Important? 2018 SIGMOD 6.4656516e-05
4,713 Learned Index Benefits: Machine Learning Based Index Performance Estimation 2022 VLDB 6.4543291e-05
5,134 Holistic Indexing in Main-memory Column-stores 2015 SIGMOD 6.2573427e-05
6,107 Breaking It Down: An In-depth Study of Index Advisors 2024 VLDB 5.8833461e-05
6,751 Progressive Indexes: Indexing for Interactive Data Analysis 2019 VLDB 5.6880934e-05
9,125 Automatic Index Selection for Large-Scale Datalog Computation 2019 VLDB 5.2245517e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 4,058 Semi-Automatic Index Tuning: Keeping DBAs in the Loop 2012 VLDB
2 5,134 Holistic Indexing in Main-memory Column-stores 2015 SIGMOD
3 9,359 Automatic SQL Error Mitigation in Oracle 2023 VLDB
4 10,615 Understanding and Detecting Query Performance Regression in Practical Index Tuning: [Experiments & Analysis] 2026 SIGMOD
5 4,234 Adaptive Statistics in Oracle 12c 2017 VLDB
6 4,007 Automated Generation of Materialized Views in Oracle 2020 VLDB
7 1,516 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD
8 598 Automatic Performance Diagnosis and Tuning in Oracle 2005 CIDR
9 10,937 Real-time SQL Plan Management in Oracle 2026 VLDB
10 529 Automatic SQL Tuning in Oracle 10g 2004 VLDB