Statistics on Views

Summary: Introduces statistics on views for the SQL Server optimizer, providing statistics on scalar and relational expressions beyond base tables. Adds a new data dimension for cardinality estimation, enabling corrections and improving plan quality on complex queries. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 9038
Venue: VLDB
Year: 2003
Pagerank: 7.1437062e-05
Overall Rank: 3,397 | 76.37%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 14 of 14 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
2,356	Consistently Estimating the Selectivity of Conjuncts of Predicates	2005	VLDB	8.9620762e-05
3,013	Cardinality Estimation Using Sample Views with Quality Assurance	2007	SIGMOD	7.7137441e-05
3,408	Query Optimizers: Time to Rethink the Contract?	2009	SIGMOD	7.1288167e-05
3,651	Conditional Selectivity for Statistics on Query Expressions	2004	SIGMOD	6.8768678e-05
3,954	Efficiently Approximating Selectivity Functions using Low Overhead Regression Models	2020	VLDB	6.5926838e-05
4,571	Adaptive Statistics in Oracle 12c	2017	VLDB	6.0773174e-05
5,668	A Pay-As-You-Go Framework for Query Execution Feedback	2008	VLDB	5.3806337e-05
5,815	StatAdvisor: Recommending Statistical Views	2009	VLDB	5.3165295e-05
6,337	Parallelizing Extensible Query Optimizers	2009	SIGMOD	5.1053757e-05
7,786	Relational Support for Flexible Schema Scenarios	2008	VLDB	4.6513838e-05
9,938	Fast Approximate Computation of Statistics on Views	2006	SIGMOD	4.2482599e-05
10,639	Cardinality Estimation for Having-Clauses	2025	VLDB	4.1945683e-05
11,084	Presto’s History-based Query Optimizer	2024	VLDB	4.1945683e-05
12,308	Filtered Statistics	2009	SIGMOD	4.1945683e-05

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
82	Answering Queries Using Views (Extended Abstract)	1995	PODS	0.00054402763
731	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD	0.00017468889
2,869	The Complexity of Transformation-Based Join Enumeration	1997	VLDB	7.9808408e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
629	Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors	2009	VLDB	0.00018942366
12,308	Filtered Statistics	2009	SIGMOD	4.1945683e-05
5,815	StatAdvisor: Recommending Statistical Views	2009	VLDB	5.3165295e-05
8,213	On the Calculation of Optimality Ranges for Relational Query Execution Plans	2018	SIGMOD	4.557937e-05
3,952	Exact Cardinality Query Optimization for Optimizer Testing	2009	VLDB	6.5939652e-05
5,633	Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server	2023	VLDB	5.4011156e-05
3,651	Conditional Selectivity for Statistics on Query Expressions	2004	SIGMOD	6.8768678e-05
790	Exploiting Statistics on Query Expressions for Optimization	2002	SIGMOD	0.0001663283
13,596	Exploiting Self-Monitoring Sample Views for Cardinality Estimation	2007	SIGMOD	-
3,013	Cardinality Estimation Using Sample Views with Quality Assurance	2007	SIGMOD	7.7137441e-05