Database Paper Browser

Back to papers

Automatic Indexing in Oracle

Summary: Automatic Indexing: production-ready, incremental engine that discovers, validates (incl. DML maintenance cost), evaluates non‑intrusively, and deploys/drops indexes (including expressions) without cloning via Resource Manager. Backed by SQL Plan Management to avoid regressions and provide accountability; shows real-world gains (~15% perf, ~60% space); in Oracle 19c/Autonomous DB. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID
14096
Venue
VLDB
Year
2025
Pagerank
4.1945683e-05
Overall Rank
10,774 | 25.05%
DOI
10.14778/3750601.3750616

Incoming Non-self Citations Over Time

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

Authors

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
71 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059038975
158 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00040071492
237 An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server 1997 VLDB 0.00031726304
359 Self-Driving Database Management Systems 2017 CIDR 0.0002592783
408 Database Cracking 2007 CIDR 0.00023953844
496 Automatic SQL Tuning in Oracle 10g 2004 VLDB 0.00021728655
516 AutoAdmin "What-if" Index Analysis Utility 1998 SIGMOD 0.00021196031
661 Database Tuning Advisor for Microsoft SQL Server 2005 2004 VLDB 0.00018481174
1,855 AI Meets AI: Leveraging Query Executions to Improve Index Recommendations 2019 SIGMOD 0.00010315245
2,047 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD 9.6920209e-05
2,229 Self-organizing Tuple Reconstruction in Column-stores 2009 SIGMOD 9.2350274e-05
2,363 Merging What’s Cracked, Cracking What’s Merged: Adaptive Indexing in Main-Memory Column-Stores 2011 VLDB 8.9580928e-05
2,987 The Uncracked Pieces in Database Cracking 2014 VLDB 7.7787088e-05
3,896 Updating a Cracked Database 2007 SIGMOD 6.6575888e-05
4,415 Semi-Automatic Index Tuning: Keeping DBAs in the Loop 2012 VLDB 6.205081e-05
4,506 Stochastic Database Cracking: Towards Robust Adaptive Indexing in Main-Memory Column-Stores 2012 VLDB 6.1319277e-05
5,113 Columnstore and B+ tree – Are Hybrid Physical Designs Important? 2018 SIGMOD 5.687445e-05
5,337 Learned Index Benefits: Machine Learning Based Index Performance Estimation 2022 VLDB 5.5635208e-05
5,376 Holistic Indexing in Main-memory Column-stores 2015 SIGMOD 5.5417421e-05
6,750 Breaking It Down: An In-depth Study of Index Advisors 2024 VLDB 4.9392771e-05
7,001 Progressive Indexes: Indexing for Interactive Data Analysis 2019 VLDB 4.8671553e-05
8,994 Automatic Index Selection for Large-Scale Datalog Computation 2019 VLDB 4.4129398e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
408 Database Cracking 2007 CIDR 0.00023953844
4,415 Semi-Automatic Index Tuning: Keeping DBAs in the Loop 2012 VLDB 6.205081e-05
9,141 Automatic SQL Error Mitigation in Oracle 2023 VLDB 4.3855791e-05
5,376 Holistic Indexing in Main-memory Column-stores 2015 SIGMOD 5.5417421e-05
10,125 Understanding and Detecting Query Performance Regression in Practical Index Tuning: [Experiments & Analysis] 2026 SIGMOD 4.1945683e-05
4,571 Adaptive Statistics in Oracle 12c 2017 VLDB 6.0773174e-05
4,623 Automated Generation of Materialized Views in Oracle 2020 VLDB 6.0411909e-05
2,047 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD 9.6920209e-05
765 Automatic Performance Diagnosis and Tuning in Oracle 2005 CIDR 0.00017016449
496 Automatic SQL Tuning in Oracle 10g 2004 VLDB 0.00021728655