Back to papers
Automated Selection of Materialized Views and Indexes for SQL Databases
Summary: End-to-end automated selection of materialized views and indexes for SQL databases, guided by workload-aware cost models. Validated experimentally; implemented as a tuning wizard in SQL Server 2000 for automated MV/index selection on general SQL workloads.
(summarized by gpt-5-nano on Feb 09 2026)
- Paper ID
- 8674
- Venue
- VLDB
- Year
- 2000
- Pagerank
- 0.00040071492
- Overall Rank
- 158 | 98.91%
- DOI
-
-
Incoming Non-self Citations Over Time
Incoming Citations (Sorted by Pagerank)
Showing 25 of 125 citing papers.
| Rank |
Citing Paper |
Year |
Venue |
Pagerank |
| 8,886 |
Provenance-based Data Skipping |
2022 |
VLDB |
4.4279829e-05 |
| 9,366 |
In-depth Analysis of Continuous Subgraph Matching in a Common Delta Query Compilation Framework |
2024 |
SIGMOD |
4.3493859e-05 |
| 9,444 |
Online Optimization and Fair Costing for Dynamic Data Sharing in a Cloud Data Market |
2014 |
SIGMOD |
4.3408772e-05 |
| 9,550 |
Supporting Distributed Feed-Following Apps over Edge Devices |
2013 |
VLDB |
4.325612e-05 |
| 9,819 |
Generating Application-Specific Data Layouts for In-memory Databases |
2019 |
VLDB |
4.2774401e-05 |
| 9,929 |
Wred: Workload Reduction for Scalable Index Tuning |
2024 |
SIGMOD |
4.2510122e-05 |
| 10,032 |
Rainbow: Risk-aware Index Benefit Estimation Facing Out Of Distribution Workloads |
2026 |
SIGMOD |
4.1945683e-05 |
| 10,116 |
Stochastic Submodular Data Forgetting |
2026 |
SIGMOD |
4.1945683e-05 |
| 10,543 |
Esc: An Early-Stopping Checker for Budget-aware Index Tuning |
2025 |
VLDB |
4.1945683e-05 |
| 10,761 |
SIEVE: Effective Filtered Vector Search with Collection of Indexes |
2025 |
VLDB |
4.1945683e-05 |
| 10,774 |
Automatic Indexing in Oracle |
2025 |
VLDB |
4.1945683e-05 |
| 10,788 |
Streaming View: An Efficient Data Processing Engine for Modern Real-time Data Warehouse of Alibaba Cloud |
2025 |
VLDB |
4.1945683e-05 |
| 10,790 |
SQL:Trek Automated Index Design at Airbnb |
2025 |
VLDB |
4.1945683e-05 |
| 10,849 |
AXE: A Task Decomposition Approach to Learned LSM Tuning |
2025 |
VLDB |
4.1945683e-05 |
| 11,539 |
FlashP: An Analytical Pipeline for Real-time Forecasting of Time-Series Relational Data |
2021 |
VLDB |
4.1945683e-05 |
| 11,542 |
View-Driven Optimization of Database-Backed Web Applications |
2020 |
CIDR |
4.1945683e-05 |
| 11,657 |
An Efficient Index for RDF Query Containment |
2019 |
SIGMOD |
4.1945683e-05 |
| 11,683 |
HERMIT in Action: Succinct Secondary Indexing Mechanism via Correlation Exploration |
2019 |
VLDB |
4.1945683e-05 |
| 12,337 |
Declarative Management in Microsoft SQL Server |
2009 |
VLDB |
4.1945683e-05 |
| 12,403 |
When is it Time to Rethink the Aggregate Configuration of Your OLAP Server? |
2008 |
VLDB |
4.1945683e-05 |
| 12,422 |
The Data Ring: Community Content Sharing |
2007 |
CIDR |
4.1945683e-05 |
| 12,474 |
Deadline and QoS Aware Data Warehouse |
2007 |
VLDB |
4.1945683e-05 |
| 12,559 |
ULoad: Choosing the Right Storage for your XML Application |
2005 |
VLDB |
4.1945683e-05 |
| 12,609 |
Speculative Query Processing |
2003 |
CIDR |
4.1945683e-05 |
| 12,653 |
SMART: Making DB2 (More) Autonomic |
2002 |
VLDB |
4.1945683e-05 |
Outgoing Citations (Sorted by Pagerank)
Showing 9 of 9 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
Semantically Similar Papers
| Overall Rank |
Paper |
Year |
Venue |
Pagerank |
| 5,060 |
Index Interactions in Physical Design Tuning: Modeling, Analysis, and Applications |
2009 |
VLDB |
5.7273583e-05 |
| 6,832 |
Stacked Indexed Views in Microsoft SQL Server |
2005 |
SIGMOD |
4.9128255e-05 |
| 11,100 |
Looking Deeply into the Magic Mirror: An Interactive Analysis of Database Index Selection Approaches |
2024 |
VLDB |
4.1945683e-05 |
| 516 |
AutoAdmin "What-if" Index Analysis Utility |
1998 |
SIGMOD |
0.00021196031 |
| 1,911 |
Algorithms for Materialized View Design in Data Warehousing Environment |
1997 |
VLDB |
0.00010120234 |
| 681 |
Materialized View Selection in a Multidimensional Database |
1997 |
VLDB |
0.00018203591 |
| 1,112 |
Materialized View Selection and Maintenance Using Multi-Query Optimization |
2001 |
SIGMOD |
0.00013917776 |
| 731 |
Optimizing Queries Using Materialized Views: A Practical, Scalable Solution |
2001 |
SIGMOD |
0.00017468889 |
| 237 |
An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server |
1997 |
VLDB |
0.00031726304 |
| 5,435 |
Materialized View and Index Selection Tool for Microsoft SQL Server 2000 |
2001 |
SIGMOD |
5.5043441e-05 |