Materialized View and Index Selection Tool for Microsoft SQL Server 2000
Summary: Recommends indexes, materialized views (indexed views), and MV indexes for SQL Server 2000 by simulating hypothetical configurations and querying the optimizer. Efficient candidate pruning, cost-based enumeration, and workload-aware comparison with the current config balance MV and index benefits. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Sanjay Agrawal (Microsoft)
- 2. Surajit Chaudhuri (Microsoft)
- 3. Vivek Narasayya (Microsoft)
BibTeX Citation
@inproceedings{agrawal_sigmod01,
title = {{Materialized View and Index Selection Tool for Microsoft SQL Server 2000}},
author = {Agrawal, Sanjay and Chaudhuri, Surajit and Narasayya, Vivek},
series = {{SIGMOD} '01},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/375663.375769},
url = {https://dl.acm.org/doi/10.1145/375663.375769},
year = {2001}
}Incoming Citations (Sorted by Pagerank)
Showing 6 of 6 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 938 | Flexible Database Generators | 2005 | VLDB | 0.00013089351 |
| 1,913 | Information-Theoretic Tools for Mining Database Structure from Large Data Sets | 2004 | SIGMOD | 9.4928569e-05 |
| 3,827 | Automatic Enforcement of Data Use Policies with DataLawyer | 2015 | SIGMOD | 7.0909359e-05 |
| 5,222 | CliffGuard: A Principled Framework for Finding Robust Database Designs | 2015 | SIGMOD | 6.3103741e-05 |
| 9,008 | Making Data Clouds Smarter at Keebo: Automated Warehouse Optimization using Data Learning | 2023 | SIGMOD | 5.3335632e-05 |
| 9,598 | Online Optimization and Fair Costing for Dynamic Data Sharing in a Cloud Data Market | 2014 | SIGMOD | 5.2494989e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 3 of 3 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 87 | Automated Selection of Materialized Views and Indexes for SQL Databases | 2000 | VLDB | 0.00035281619 |
| 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 | 501 | Database Tuning Advisor for Microsoft SQL Server 2005 | 2004 | VLDB |
| 2 | 11,306 | Looking Deeply into the Magic Mirror: An Interactive Analysis of Database Index Selection Approaches | 2024 | VLDB |
| 3 | 387 | AutoAdmin "What-if" Index Analysis Utility | 1998 | SIGMOD |
| 4 | 4,550 | Index Interactions in Physical Design Tuning: Modeling, Analysis, and Applications | 2009 | VLDB |
| 5 | 559 | Optimizing Queries Using Materialized Views: A Practical, Scalable Solution | 2001 | SIGMOD |
| 6 | 6,671 | Stacked Indexed Views in Microsoft SQL Server | 2005 | SIGMOD |
| 7 | 3,777 | Database Tuning Advisor for Microsoft SQL Server 2005: Demo | 2005 | SIGMOD |
| 8 | 1,870 | Microsoft Index Tuning Wizard for SQL Server 7.0 | 1998 | SIGMOD |
| 9 | 156 | An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server | 1997 | VLDB |
| 10 | 87 | Automated Selection of Materialized Views and Indexes for SQL Databases | 2000 | VLDB |