DBScholar

Back to papers

AutoAdmin "What-if" Index Analysis Utility

Summary: AutoAdmin: what-if index analysis tool for SQL Server 7.0; quantifies current indexes and evaluates hypothetical ones. Offers interfaces and techniques to assess workload, cost, and index usage under projected data growth for extensible physical design analysis. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
3090
Venue
SIGMOD
Year
1998
Pagerank
0.00019442332
Overall Rank
387 | 97.35%
DOI
10.1145/276304.276337

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{chaudhuri_sigmod98,
        title = {{AutoAdmin "What-if" Index Analysis Utility}},
        author = {Chaudhuri, Surajit and Narasayya, Vivek},
        series = {{SIGMOD} '98},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/276304.276337},
        url = {https://dl.acm.org/doi/10.1145/276304.276337},
        year = {1998}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 72 citing papers.

Rank Citing Paper Year Venue Pagerank
86 Automatic Database Management System Tuning Through Large-scale Machine Learning 2017 SIGMOD 0.00035316107
87 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00035281619
184 DB2 Design Advisor: Integrated Automatic Physical Database Design 2004 VLDB 0.00026256101
199 Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design 2004 SIGMOD 0.00025612088
234 Self-Driving Database Management Systems 2017 CIDR 0.00023810722
334 An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning 2019 SIGMOD 0.00020875082
347 Tuning Database Configuration Parameters with iTuned 2009 VLDB 0.00020651582
363 Approximate Query Processing: Taming the TeraBytes! A Tutorial 2001 VLDB 0.0002005475
471 Skew-Aware Automatic Database Partitioning in Shared-Nothing, Parallel OLTP Systems 2012 SIGMOD 0.0001793564
501 Database Tuning Advisor for Microsoft SQL Server 2005 2004 VLDB 0.0001738508
664 Exploiting Statistics on Query Expressions for Optimization 2002 SIGMOD 0.00015167825
768 Automatic Physical Database Tuning: A Relaxation-based Approach 2005 SIGMOD 0.00014173242
1,279 AI Meets AI: Leveraging Query Executions to Improve Index Recommendations 2019 SIGMOD 0.00011361878
1,344 An Inquiry into Machine Learning-based Automatic Configuration Tuning Services on Real-World Database Management Systems 2021 VLDB 0.00011094717
1,548 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD 0.00010392475
1,694 PerfXplain: Debugging MapReduce Job Performance 2012 VLDB 9.9953156e-05
1,831 On Predictive Modeling for Optimizing Transaction Execution in Parallel OLTP Systems 2012 VLDB 9.6635729e-05
1,852 Automated Partitioning Design in Parallel Database Systems 2011 SIGMOD 9.6134443e-05
1,870 Microsoft Index Tuning Wizard for SQL Server 7.0 1998 SIGMOD 9.579726e-05
2,364 To Tune or not to Tune? A Lightweight Physical Design Alerter 2006 VLDB 8.6869645e-05
2,811 Constrained Physical Design Tuning 2008 VLDB 8.0982817e-05
3,003 Configuration-Parametric Query Optimization for Physical Design Tuning 2008 SIGMOD 7.8620915e-05
3,662 openGauss: An Autonomous Database System 2021 VLDB 7.2166682e-05
3,777 Database Tuning Advisor for Microsoft SQL Server 2005: Demo 2005 SIGMOD 7.1347483e-05
3,891 Storage Workload Estimation for Database Management Systems 2007 SIGMOD 7.0432571e-05
3,930 Data Canopy: Accelerating Exploratory Statistical Analysis 2017 SIGMOD 7.0102082e-05
4,101 Automated Generation of Materialized Views in Oracle 2020 VLDB 6.9009734e-05
4,198 Primitives for Workload Summarization and Implications for SQL 2003 VLDB 6.8397659e-05
4,489 COLT: Continuous On-Line Database Tuning 2006 SIGMOD 6.6675192e-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
4,904 Mining Precision Interfaces From Query Logs 2019 SIGMOD 6.4503063e-05
5,039 Holistic Indexing in Main-memory Column-stores 2015 SIGMOD 6.3909067e-05
5,056 The Case for Data Visualization Management Systems 2014 VLDB 6.3823595e-05
5,091 Budget-aware Index Tuning with Reinforcement Learning 2022 SIGMOD 6.3669569e-05
5,307 Materialized View and Index Selection Tool for Microsoft SQL Server 2000 2001 SIGMOD 6.2728074e-05
5,470 Efficient Computation of Multiple Group By Queries 2005 SIGMOD 6.2070458e-05
5,497 JECB: a Join-Extension, Code-Based Approach to OLTP Data Partitioning 2014 SIGMOD 6.1973614e-05
5,558 HMAB: Self-Driving Hierarchy of Bandits for Integrated Physical Database Design Tuning 2023 VLDB 6.1749098e-05
5,766 Endure: A Robust Tuning Paradigm for LSM Trees Under Workload Uncertainty 2022 VLDB 6.094771e-05
5,767 A Comparative Study and Component Analysis of Query Plan Representation Techniques in ML4DB Studies 2024 VLDB 6.0945741e-05
5,869 ISUM: Efficiently Compressing Large and Complex Workloads for Scalable Index Tuning 2022 SIGMOD 6.0610922e-05
5,974 Towards instance-optimized data systems 2021 VLDB 6.0230488e-05
6,429 Just-In-Time Data Structures 2015 CIDR 5.8805678e-05
6,651 Progressive Indexes: Indexing for Interactive Data Analysis 2019 VLDB 5.8141997e-05
6,753 Optimal Indexing Using Near-Minimal Space [Extended Abstract] 2003 PODS 5.7836523e-05
6,848 Jigsaw: A Data Storage and Query Processing Engine for Irregular Table Partitioning 2021 SIGMOD 5.7550624e-05
7,076 Refactoring Index Tuning Process with Benefit Estimation 2024 VLDB 5.7098893e-05
7,589 Cost-Intelligent Data Analytics in the Cloud 2024 CIDR 5.5907048e-05
7,750 DISTILL: Low-Overhead Data-Driven Techniques for Filtering and Costing Indexes for Scalable Index Tuning 2022 VLDB 5.5523652e-05
Previous Page 1 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 5 of 5 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
11 Implementing Data Cubes Efficiently 1996 SIGMOD 0.00071822821
156 An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server 1997 VLDB 0.00028636811
508 Random Sampling for Histogram Construction: How much is enough? 1998 SIGMOD 0.00017275873
1,272 A Framework for Automating Physical Database Design 1991 VLDB 0.0001138436
1,695 Hypothetical Data Bases As Views 1981 SIGMOD 9.9840256e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 5,307 Materialized View and Index Selection Tool for Microsoft SQL Server 2000 2001 SIGMOD
2 4,643 Learned Index Benefits: Machine Learning Based Index Performance Estimation 2022 VLDB
3 11,306 Looking Deeply into the Magic Mirror: An Interactive Analysis of Database Index Selection Approaches 2024 VLDB
4 1,548 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD
5 4,550 Index Interactions in Physical Design Tuning: Modeling, Analysis, and Applications 2009 VLDB
6 87 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB
7 854 Index Selection in a Self-Adaptive Data Base Management System 1976 SIGMOD
8 8,641 Automatic Workload Driven Index Defragmentation 2011 VLDB
9 1,870 Microsoft Index Tuning Wizard for SQL Server 7.0 1998 SIGMOD
10 156 An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server 1997 VLDB