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 50 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.00070860346 |
| 746 | Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time | 1996 | SIGMOD | 0.0001426147 |
| 869 | Index Selection in a Self-Adaptive Data Base Management System | 1976 | SIGMOD | 0.00013326654 |
| 1,265 | A Framework for Automating Physical Database Design | 1991 | VLDB | 0.00011257062 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 5,149 | Holistic Indexing in Main-memory Column-stores | 2015 | SIGMOD |
| 2 | 1,517 | 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,988 | Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL Server | 2026 | VLDB |
| 5 | 5,450 | Materialized View and Index Selection Tool for Microsoft SQL Server 2000 | 2001 | SIGMOD |
| 6 | 11,678 | Looking Deeply into the Magic Mirror: An Interactive Analysis of Database Index Selection Approaches | 2024 | VLDB |
| 7 | 380 | AutoAdmin "What-if" Index Analysis Utility | 1998 | SIGMOD |
| 8 | 1,916 | Microsoft Index Tuning Wizard for SQL Server 7.0 | 1998 | SIGMOD |
| 9 | 1,400 | Magic mirror in my hand, which is the best in the land? An Experimental Evaluation of Index Selection Algorithms | 2020 | VLDB |
| 10 | 89 | Automated Selection of Materialized Views and Indexes for SQL Databases | 2000 | VLDB |