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: 9039
Venue: VLDB
Year: 2003
Pagerank: 7.1381433e-05
Overall Rank: 3,398 | 76.39%
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,359	Consistently Estimating the Selectivity of Conjuncts of Predicates	2005	VLDB	8.967267e-05
3,013	Cardinality Estimation Using Sample Views with Quality Assurance	2007	SIGMOD	7.7082045e-05
3,402	Query Optimizers: Time to Rethink the Contract?	2009	SIGMOD	7.134261e-05
3,656	Conditional Selectivity for Statistics on Query Expressions	2004	SIGMOD	6.8712579e-05
3,955	Efficiently Approximating Selectivity Functions using Low Overhead Regression Models	2020	VLDB	6.5895015e-05
4,566	Adaptive Statistics in Oracle 12c	2017	VLDB	6.073045e-05
5,676	A Pay-As-You-Go Framework for Query Execution Feedback	2008	VLDB	5.3768269e-05
5,824	StatAdvisor: Recommending Statistical Views	2009	VLDB	5.311975e-05
6,333	Parallelizing Extensible Query Optimizers	2009	SIGMOD	5.1013149e-05
7,786	Relational Support for Flexible Schema Scenarios	2008	VLDB	4.6469243e-05
9,937	Fast Approximate Computation of Statistics on Views	2006	SIGMOD	4.2441896e-05
10,647	Cardinality Estimation for Having-Clauses	2025	VLDB	4.1905499e-05
11,087	Presto’s History-based Query Optimizer	2024	VLDB	4.1905499e-05
12,316	Filtered Statistics	2009	SIGMOD	4.1905499e-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.00054430106
728	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD	0.00017459654
2,878	The Complexity of Transformation-Based Join Enumeration	1997	VLDB	7.9694937e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
627	Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors	2009	VLDB	0.00018959896
12,316	Filtered Statistics	2009	SIGMOD	4.1905499e-05
5,824	StatAdvisor: Recommending Statistical Views	2009	VLDB	5.311975e-05
8,193	On the Calculation of Optimality Ranges for Relational Query Execution Plans	2018	SIGMOD	4.5575291e-05
3,943	Exact Cardinality Query Optimization for Optimizer Testing	2009	VLDB	6.6067351e-05
5,639	Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server	2023	VLDB	5.3972261e-05
3,656	Conditional Selectivity for Statistics on Query Expressions	2004	SIGMOD	6.8712579e-05
786	Exploiting Statistics on Query Expressions for Optimization	2002	SIGMOD	0.00016624743
13,609	Exploiting Self-Monitoring Sample Views for Cardinality Estimation	2007	SIGMOD	-
3,013	Cardinality Estimation Using Sample Views with Quality Assurance	2007	SIGMOD	7.7082045e-05