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: 3634
Venue: SIGMOD
Year: 2005
Pagerank: 4.9128255e-05
Overall Rank: 6,832 | 52.48%
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,476	Efficient Exploitation of Similar Subexpressions for Query Processing	2007	SIGMOD	0.00011779092
4,574	Incremental View Maintenance over Array Data	2017	SIGMOD	6.0738556e-05
6,881	Query Evaluation using Overlapping Views: Completeness and Efficiency	2006	SIGMOD	4.8964953e-05
8,704	Equivalence of Nested Queries with Mixed Semantics	2009	PODS	4.4647149e-05
8,826	Delta: Scalable Data Dissemination under Capacity Constraints	2014	VLDB	4.441364e-05
9,366	In-depth Analysis of Continuous Subgraph Matching in a Common Delta Query Compilation Framework	2024	SIGMOD	4.3493859e-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.0011708144
55	Efficiently Updating Materialized Views	1986	SIGMOD	0.00065762967
95	Maintaining Views Incrementally	1993	SIGMOD	0.00050896659
158	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00040071492
248	Eager Aggregation and Lazy Aggregation	1995	VLDB	0.00030785339
416	Computing Queries from Derived Relations	1985	VLDB	0.0002380776
468	Materialized Views In Oracle	1998	VLDB	0.00022411821
578	The GMAP: A Versatile Tool for Physical Data Independence	1994	VLDB	0.00019838707
731	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD	0.00017468889
962	Maintenance of Data Cubes and Summary Tables in a Warehouse	1997	SIGMOD	0.00014986226
1,059	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD	0.00014382575
1,421	Algorithms for Deferred View Maintenance	1996	SIGMOD	0.0001205793
2,869	The Complexity of Transformation-Based Join Enumeration	1997	VLDB	7.9808408e-05
3,037	How To Roll a Join: Asynchronous Incremental View Maintenance	2000	SIGMOD	7.6731715e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
3,397	Statistics on Views	2003	VLDB	7.1437062e-05
5,435	Materialized View and Index Selection Tool for Microsoft SQL Server 2000	2001	SIGMOD	5.5043441e-05
1,617	Adapting Materialized Views after Redefinitions	1995	SIGMOD	0.00011119837
653	A Performance Analysis of View Materialization Strategies	1987	SIGMOD	0.00018626606
9,447	Towards Adaptive Storage Views in Virtual Memory	2023	CIDR	4.3402941e-05
2,022	Lazy Maintenance of Materialized Views	2007	VLDB	9.754634e-05
1,112	Materialized View Selection and Maintenance Using Multi-Query Optimization	2001	SIGMOD	0.00013917776
158	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00040071492
584	Answering Queries with Aggregation Using Views	1996	VLDB	0.0001971526
731	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD	0.00017468889