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

1. Surajit Chaudhuri (Microsoft)
2. Vivek Narasayya (Microsoft)

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

Rank	Citing Paper	Year	Venue	Pagerank
7,770	Automated design of multidimensional clustering tables for relational databases	2004	VLDB	5.5474421e-05
7,846	The Holon Approach for Simultaneously Tuning Multiple Components in a Self-Driving Database Management System with Machine Learning via Synthesized Proto-Actions	2024	VLDB	5.5331459e-05
8,076	Leveraging Dynamic and Heterogeneous Workload Knowledge to Boost the Performance of Index Advisors	2024	VLDB	5.4927414e-05
8,601	Goals and Benchmarks for Autonomic Configuration Recommenders	2005	SIGMOD	5.4048965e-05
8,703	Divergent Physical Design Tuning for Replicated Databases	2012	SIGMOD	5.3813751e-05
8,783	Tiresias: Enabling Predictive Autonomous Storage and Indexing	2022	VLDB	5.3740362e-05
8,864	Pipemizer: An Optimizer for Analytics Data Pipelines	2022	VLDB	5.355022e-05
8,927	Hyperspace: The Indexing Subsystem of Azure Synapse	2021	VLDB	5.3483178e-05
8,982	Automatic Index Selection for Large-Scale Datalog Computation	2019	VLDB	5.3397715e-05
9,106	AirIndex: Versatile Index Tuning Through Data and Storage	2023	SIGMOD	5.3226167e-05
9,441	Db2une: Tuning Under Pressure via Deep Learning	2024	VLDB	5.2678428e-05
9,615	Wii: Dynamic Budget Reallocation In Index Tuning	2024	SIGMOD	5.2436464e-05
10,082	Wred: Workload Reduction for Scalable Index Tuning	2024	SIGMOD	5.1587525e-05
10,413	Understanding and Detecting Query Performance Regression in Practical Index Tuning: [Experiments & Analysis]	2026	SIGMOD	5.093636e-05
10,494	RIB: Robust Learning-based Index Benefit Estimation	2026	SIGMOD	5.093636e-05
10,506	This is Going to Sound Crazy, But What If We Used Large Language Models to Boost Automatic Database Tuning Algorithms By Leveraging Prior History? We Will Find Better Configurations More Quickly Than Retraining From Scratch!	2026	SIGMOD	5.093636e-05
10,518	Breaking the Isolation-Freshness Trade-off: Joint Adaptive Storage Optimization for HTAP Systems	2026	VLDB	5.093636e-05
10,815	Esc: An Early-Stopping Checker for Budget-aware Index Tuning	2025	VLDB	5.093636e-05
11,003	Automatic Indexing in Oracle	2025	VLDB	5.093636e-05
11,150	Proactive Resume and Pause of Resources for Microsoft Azure SQL Database Serverless	2024	SIGMOD	5.093636e-05
11,277	Index Advisors on Quantum Platforms	2024	VLDB	5.093636e-05
12,846	SMART: Making DB2 (More) Autonomic	2002	VLDB	5.093636e-05

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

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