Stacked Indexed Views in Microsoft SQL Server

Summary: Introduces stacked (view-on-view) indexed views in SQL Server, letting materialized views reference other views besides base tables to support a broader class of queries. Adds a signature-based optimizer for view matching, speeding up stacking and improving matching for regular views. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 3635
Venue: SIGMOD
Year: 2005
Pagerank: 4.9081078e-05
Overall Rank: 6,830 | 52.54%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 6 of 6 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,475	Efficient Exploitation of Similar Subexpressions for Query Processing	2007	SIGMOD	0.00011765071
4,573	Incremental View Maintenance over Array Data	2017	SIGMOD	6.0680332e-05
6,884	Query Evaluation using Overlapping Views: Completeness and Efficiency	2006	SIGMOD	4.8917858e-05
8,699	Equivalence of Nested Queries with Mixed Semantics	2009	PODS	4.4604187e-05
8,826	Delta: Scalable Data Dissemination under Capacity Constraints	2014	VLDB	4.4371065e-05
9,375	In-depth Analysis of Continuous Subgraph Matching in a Common Delta Query Compilation Framework	2024	SIGMOD	4.3452177e-05

Outgoing Citations (Sorted by Pagerank)

Showing 14 of 14 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.0011695087
55	Efficiently Updating Materialized Views	1986	SIGMOD	0.00065687017
97	Maintaining Views Incrementally	1993	SIGMOD	0.00050863077
160	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00040053897
249	Eager Aggregation and Lazy Aggregation	1995	VLDB	0.00030773137
413	Computing Queries from Derived Relations	1985	VLDB	0.00023802724
470	Materialized Views In Oracle	1998	VLDB	0.00022386815
578	The GMAP: A Versatile Tool for Physical Data Independence	1994	VLDB	0.00019825485
728	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD	0.00017459654
963	Maintenance of Data Cubes and Summary Tables in a Warehouse	1997	SIGMOD	0.00014975448
1,059	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD	0.00014370009
1,428	Algorithms for Deferred View Maintenance	1996	SIGMOD	0.00012030912
2,878	The Complexity of Transformation-Based Join Enumeration	1997	VLDB	7.9694937e-05
3,038	How To Roll a Join: Asynchronous Incremental View Maintenance	2000	SIGMOD	7.6712282e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
3,398	Statistics on Views	2003	VLDB	7.1381433e-05
5,445	Materialized View and Index Selection Tool for Microsoft SQL Server 2000	2001	SIGMOD	5.499851e-05
1,620	Adapting Materialized Views after Redefinitions	1995	SIGMOD	0.00011112989
658	A Performance Analysis of View Materialization Strategies	1987	SIGMOD	0.00018566555
9,368	Towards Adaptive Storage Views in Virtual Memory	2023	CIDR	4.3465335e-05
2,026	Lazy Maintenance of Materialized Views	2007	VLDB	9.7466372e-05
1,110	Materialized View Selection and Maintenance Using Multi-Query Optimization	2001	SIGMOD	0.00013902997
160	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00040053897
583	Answering Queries with Aggregation Using Views	1996	VLDB	0.00019705383
728	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD	0.00017459654