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 |
|---|---|---|---|---|
| 187 | DB2 Design Advisor: Integrated Automatic Physical Database Design | 2004 | VLDB | 0.0002592488 |
| 243 | Automating Physical Database Design in a Parallel Database | 2002 | SIGMOD | 0.00023358891 |
| 2,994 | The Value of Merge-Join and Hash-Join in SQL Server | 1999 | VLDB | 7.7710643e-05 |
| 4,415 | Estimating Compilation Time of a Query Optimizer | 2003 | SIGMOD | 6.6094699e-05 |
| 6,144 | The BUDS Language for Distributed Bayesian Machine Learning | 2017 | SIGMOD | 5.8717563e-05 |
| 7,845 | Automated design of multidimensional clustering tables for relational databases | 2004 | VLDB | 5.4420146e-05 |
| 8,751 | Goals and Benchmarks for Autonomic Configuration Recommenders | 2005 | SIGMOD | 5.284914e-05 |
| 13,136 | SMART: Making DB2 (More) Autonomic | 2002 | VLDB | 4.9793485e-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 |
|---|---|---|---|---|
| 151 | An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server | 1997 | VLDB | 0.00028672526 |
| 378 | AutoAdmin "What-if" Index Analysis Utility | 1998 | SIGMOD | 0.00019549382 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 10,604 | Understanding and Detecting Query Performance Regression in Practical Index Tuning: [Experiments & Analysis] | 2026 | SIGMOD |
| 2 | 4,607 | Index Interactions in Physical Design Tuning: Modeling, Analysis, and Applications | 2009 | VLDB |
| 3 | 10,918 | Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL Server | 2026 | VLDB |
| 4 | 1,516 | Automatically Indexing Millions of Databases in Microsoft Azure SQL Database | 2019 | SIGMOD |
| 5 | 88 | Automated Selection of Materialized Views and Indexes for SQL Databases | 2000 | VLDB |
| 6 | 11,625 | Looking Deeply into the Magic Mirror: An Interactive Analysis of Database Index Selection Approaches | 2024 | VLDB |
| 7 | 3,844 | Database Tuning Advisor for Microsoft SQL Server 2005: Demo | 2005 | SIGMOD |
| 8 | 5,430 | Materialized View and Index Selection Tool for Microsoft SQL Server 2000 | 2001 | SIGMOD |
| 9 | 378 | AutoAdmin "What-if" Index Analysis Utility | 1998 | SIGMOD |
| 10 | 151 | An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server | 1997 | VLDB |