An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server
Summary: Industrial-strength SQL Server index advisor that stays synchronized with the optimizer for cost-driven workload tuning. Prunes syntactically/cost-inferior candidates, accelerates index-set evaluation, and iteratively handles multicolumn indexes, achieving near-optimal choices efficiently. (summarized by gpt-5.6-luna on Jul 24 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Surajit Chaudhuri (Microsoft)
- 2. Vivek Narasayya (Microsoft)
BibTeX Citation
@article{chaudhuri_vldb97,
title = {{An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server}},
author = {Chaudhuri, Surajit and Narasayya, Vivek},
journal = {PVLDB},
series = {{VLDB} '97},
pages = {146},
year = {1997}
}Incoming Citations (Sorted by Pagerank)
Showing 20 of 120 citing papers.
Outgoing Citations (Sorted by Pagerank)
Showing 4 of 4 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.00071084324 |
| 744 | Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time | 1996 | SIGMOD | 0.00014309622 |
| 867 | Index Selection in a Self-Adaptive Data Base Management System | 1976 | SIGMOD | 0.00013371725 |
| 1,262 | A Framework for Automating Physical Database Design | 1991 | VLDB | 0.00011287644 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 5,131 | Holistic Indexing in Main-memory Column-stores | 2015 | SIGMOD |
| 2 | 1,516 | Automatically Indexing Millions of Databases in Microsoft Azure SQL Database | 2019 | SIGMOD |
| 3 | 1,527 | On the Analysis of Indexing Schemes | 1997 | PODS |
| 4 | 10,918 | Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL Server | 2026 | VLDB |
| 5 | 5,430 | Materialized View and Index Selection Tool for Microsoft SQL Server 2000 | 2001 | SIGMOD |
| 6 | 11,625 | Looking Deeply into the Magic Mirror: An Interactive Analysis of Database Index Selection Approaches | 2024 | VLDB |
| 7 | 378 | AutoAdmin "What-if" Index Analysis Utility | 1998 | SIGMOD |
| 8 | 1,905 | Microsoft Index Tuning Wizard for SQL Server 7.0 | 1998 | SIGMOD |
| 9 | 1,397 | Magic mirror in my hand, which is the best in the land? An Experimental Evaluation of Index Selection Algorithms | 2020 | VLDB |
| 10 | 88 | Automated Selection of Materialized Views and Indexes for SQL Databases | 2000 | VLDB |