StatAdvisor: Recommending Statistical Views

Summary: Recommends automatic statistical views for a given workload to improve intermediate-cardinality estimates. Introduces plan-based candidate enumeration and benefit-based analysis to select views, validated via a DB2 prototype in the Design Advisor. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 9904
Venue: VLDB
Year: 2009
Pagerank: 5.3165295e-05
Overall Rank: 5,815 | 59.55%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 7 of 7 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
2,156	SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning	2018	VLDB	9.4170209e-05
2,219	SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning	2019	SIGMOD	9.2623533e-05
2,588	Database Learning: Toward a Database that Becomes Smarter Every Time	2017	SIGMOD	8.4909562e-05
4,571	Adaptive Statistics in Oracle 12c	2017	VLDB	6.0773174e-05
7,127	Guided automated learning for query workload re-optimization	2019	VLDB	4.8230386e-05
8,680	A Practical Approach to Groupjoin and Nested Aggregates	2021	VLDB	4.4694927e-05
11,084	Presto’s History-based Query Optimizer	2024	VLDB	4.1945683e-05

Outgoing Citations (Sorted by Pagerank)

Showing 18 of 18 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
18	On Random Sampling over Joins	1999	SIGMOD	0.00092385438
46	Simple Random Sampling from Relational Databases	1986	VLDB	0.00070894702
99	On the Propagation of Errors in the Size of Join Results	1991	SIGMOD	0.00050022914
158	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00040071492
182	LEO - DB2's LEarning Optimizer	2001	VLDB	0.00036962631
211	Join Synopses for Approximate Query Answering	1999	SIGMOD	0.00033981214
220	Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans	1998	SIGMOD	0.00033194808
224	CORDS: Automatic Discovery of Correlations and Soft Functional Dependencies	2004	SIGMOD	0.00032746205
258	DB2 Design Advisor: Integrated Automatic Physical Database Design	2004	VLDB	0.0003022091
650	Robust Query Processing through Progressive Optimization	2004	SIGMOD	0.00018659177
684	Towards a Robust Query Optimizer: A Principled and Practical Approach	2005	SIGMOD	0.00018179769
790	Exploiting Statistics on Query Expressions for Optimization	2002	SIGMOD	0.0001663283
1,059	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD	0.00014382575
1,272	Proactive Re-Optimization	2005	SIGMOD	0.00012920076
3,013	Cardinality Estimation Using Sample Views with Quality Assurance	2007	SIGMOD	7.7137441e-05
3,397	Statistics on Views	2003	VLDB	7.1437062e-05
3,651	Conditional Selectivity for Statistics on Query Expressions	2004	SIGMOD	6.8768678e-05
5,025	Automated Statistics Collection in DB2 UDB	2004	VLDB	5.7533741e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
158	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00040071492
9,938	Fast Approximate Computation of Statistics on Views	2006	SIGMOD	4.2482599e-05
684	Towards a Robust Query Optimizer: A Principled and Practical Approach	2005	SIGMOD	0.00018179769
3,583	A Formal Perspective on the View Selection Problem	2001	VLDB	6.9463532e-05
3,651	Conditional Selectivity for Statistics on Query Expressions	2004	SIGMOD	6.8768678e-05
4,571	Adaptive Statistics in Oracle 12c	2017	VLDB	6.0773174e-05
790	Exploiting Statistics on Query Expressions for Optimization	2002	SIGMOD	0.0001663283
1,019	Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques	2012	VLDB	0.00014625603
258	DB2 Design Advisor: Integrated Automatic Physical Database Design	2004	VLDB	0.0003022091
3,397	Statistics on Views	2003	VLDB	7.1437062e-05