Microsoft Index Tuning Wizard for SQL Server 7.0
Summary: Automates index selection for a given workload on SQL Server 7.0 (Sphinx) via a tuning wizard. It delivers quantitative impact analyses (expected performance change, storage cost, and index usage) and supports immediate or scheduled index creation. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Surajit Chaudhuri (Microsoft)
- 2. Vivek Narasayya (Microsoft)
BibTeX Citation
@inproceedings{chaudhuri_sigmod98,
title = {{Microsoft Index Tuning Wizard for SQL Server 7.0}},
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.276378},
url = {https://dl.acm.org/doi/10.1145/276304.276378},
year = {1998}
}Incoming Citations (Sorted by Pagerank)
Showing 8 of 8 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 184 | DB2 Design Advisor: Integrated Automatic Physical Database Design | 2004 | VLDB | 0.00026256101 |
| 246 | Automating Physical Database Design in a Parallel Database | 2002 | SIGMOD | 0.00023457421 |
| 2,952 | The Value of Merge-Join and Hash-Join in SQL Server | 1999 | VLDB | 7.9255489e-05 |
| 4,346 | Estimating Compilation Time of a Query Optimizer | 2003 | SIGMOD | 6.7510183e-05 |
| 6,030 | The BUDS Language for Distributed Bayesian Machine Learning | 2017 | SIGMOD | 6.0009079e-05 |
| 7,770 | Automated design of multidimensional clustering tables for relational databases | 2004 | VLDB | 5.5474421e-05 |
| 8,601 | Goals and Benchmarks for Autonomic Configuration Recommenders | 2005 | SIGMOD | 5.4048965e-05 |
| 12,846 | SMART: Making DB2 (More) Autonomic | 2002 | VLDB | 5.093636e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 2 of 2 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 156 | An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server | 1997 | VLDB | 0.00028636811 |
| 387 | AutoAdmin "What-if" Index Analysis Utility | 1998 | SIGMOD | 0.00019442332 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 9,715 | Kaizen: A Semi-Automatic Index Advisor | 2012 | SIGMOD |
| 2 | 10,413 | Understanding and Detecting Query Performance Regression in Practical Index Tuning: [Experiments & Analysis] | 2026 | SIGMOD |
| 3 | 4,550 | Index Interactions in Physical Design Tuning: Modeling, Analysis, and Applications | 2009 | VLDB |
| 4 | 1,548 | Automatically Indexing Millions of Databases in Microsoft Azure SQL Database | 2019 | SIGMOD |
| 5 | 87 | Automated Selection of Materialized Views and Indexes for SQL Databases | 2000 | VLDB |
| 6 | 11,306 | Looking Deeply into the Magic Mirror: An Interactive Analysis of Database Index Selection Approaches | 2024 | VLDB |
| 7 | 3,777 | Database Tuning Advisor for Microsoft SQL Server 2005: Demo | 2005 | SIGMOD |
| 8 | 5,307 | Materialized View and Index Selection Tool for Microsoft SQL Server 2000 | 2001 | SIGMOD |
| 9 | 387 | AutoAdmin "What-if" Index Analysis Utility | 1998 | SIGMOD |
| 10 | 156 | An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server | 1997 | VLDB |