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: hd02074eeb8297a91
Venue: SIGMOD
Year: 1998
Pagerank: 0.00019530546
Overall Rank: 380 | 97.46%
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 25 of 75 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
7,838	Automated design of multidimensional clustering tables for relational databases	2004	VLDB	5.4264579e-05
7,844	Bespoke OLAP: Synthesizing Workload-Specific One-size-fits-one Database Engines	2026	VLDB	5.4255843e-05
7,921	DISTILL: Low-Overhead Data-Driven Techniques for Filtering and Costing Indexes for Scalable Index Tuning	2022	VLDB	5.4098206e-05
7,989	Leveraging Dynamic and Heterogeneous Workload Knowledge to Boost the Performance of Index Advisors	2024	VLDB	5.3951416e-05
7,997	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.3938336e-05
8,558	AirIndex: Versatile Index Tuning Through Data and Storage	2023	SIGMOD	5.3016395e-05
8,780	Goals and Benchmarks for Autonomic Configuration Recommenders	2005	SIGMOD	5.2650571e-05
8,798	Automatic Indexing in Oracle	2025	VLDB	5.2606925e-05
8,892	Divergent Physical Design Tuning for Replicated Databases	2012	SIGMOD	5.2420764e-05
8,902	Tiresias: Enabling Predictive Autonomous Storage and Indexing	2022	VLDB	5.2387388e-05
8,998	Pipemizer: An Optimizer for Analytics Data Pipelines	2022	VLDB	5.2273528e-05
9,117	Hyperspace: The Indexing Subsystem of Azure Synapse	2021	VLDB	5.208561e-05
9,144	Automatic Index Selection for Large-Scale Datalog Computation	2019	VLDB	5.2072761e-05
9,655	Db2une: Tuning Under Pressure via Deep Learning	2024	VLDB	5.1307018e-05
9,829	Wii: Dynamic Budget Reallocation In Index Tuning	2024	SIGMOD	5.1066866e-05
9,983	Wred: Workload Reduction for Scalable Index Tuning	2024	SIGMOD	5.0860177e-05
10,323	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.0241309e-05
10,676	Understanding and Detecting Query Performance Regression in Practical Index Tuning: [Experiments & Analysis]	2026	SIGMOD	4.9605343e-05
10,753	RIB: Robust Learning-based Index Benefit Estimation	2026	SIGMOD	4.9605343e-05
10,774	Breaking the Isolation-Freshness Trade-off: Joint Adaptive Storage Optimization for HTAP Systems	2026	VLDB	4.9605343e-05
10,986	AutoLiquid: Autonomic Data Layout Optimization for the Databricks Lakehouse	2026	VLDB	4.9605343e-05
10,988	Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL Server	2026	VLDB	4.9605343e-05
11,288	Esc: An Early-Stopping Checker for Budget-aware Index Tuning	2025	VLDB	4.9605343e-05
11,556	Proactive Resume and Pause of Resources for Microsoft Azure SQL Database Serverless	2024	SIGMOD	4.9605343e-05
13,183	SMART: Making DB2 (More) Autonomic	2002	VLDB	4.9605343e-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.00070860346
151	An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server	1997	VLDB	0.00028611216
518	Random Sampling for Histogram Construction: How much is enough?	1998	SIGMOD	0.00016918797
1,265	A Framework for Automating Physical Database Design	1991	VLDB	0.00011257062
1,718	Hypothetical Data Bases As Views	1981	SIGMOD	9.786481e-05

Semantically Similar Papers

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