Automated Statistics Collection in DB2 UDB

Summary: DB2 UDB’s Automated Statistics Collection autonomously selects and refreshes statistics using both update/delete/insert activity and query feedback. This hybrid, workload-aware approach handles unforeseen queries and can improve performance by orders of magnitude without DBA intervention. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: 9323
Venue: VLDB
Year: 2004
Pagerank: 6.614318e-05
Overall Rank: 4,591 | 68.51%
DOI: 10.1016/B978-012088469-8.50100-5

Incoming Non-self Citations Over Time

Authors

1. A. Aboulnaga (IBM)
2. P. Haas (IBM)
3. M. Kandil (IBM)
4. S. Lightstone (IBM)
5. G. Lohman (IBM)
6. V. Markl (IBM)
7. I. Popivanov (IBM)
8. V. Raman (IBM)

BibTeX Citation

@article{aboulnaga_vldb04,
        title = {{Automated Statistics Collection in DB2 UDB}},
        author = {Aboulnaga, A. and Haas, P. and Kandil, M. and Lightstone, S. and Lohman, G. and Markl, V. and Popivanov, I. and Raman, V.},
        journal = {PVLDB},
        series = {{VLDB} '04},
        doi = {10.1016/B978-012088469-8.50100-5},
        url = {https://doi.org/10.1016/B978-012088469-8.50100-5},
        year = {2004}
}

Incoming Citations (Sorted by Pagerank)

Showing 14 of 14 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,712	SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning	2019	SIGMOD	9.9492299e-05
1,815	SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning	2018	VLDB	9.6894541e-05
1,936	Consistently Estimating the Selectivity of Conjuncts of Predicates	2005	VLDB	9.4557372e-05
2,269	GORDIAN: Efficient and Scalable Discovery of Composite Keys	2006	VLDB	8.8328424e-05
2,589	Statistical Learning Techniques for Costing XML Queries	2005	VLDB	8.371643e-05
3,426	Exact Cardinality Query Optimization for Optimizer Testing	2009	VLDB	7.4218997e-05
5,365	A Pay-As-You-Go Framework for Query Execution Feedback	2008	VLDB	6.2462467e-05
5,514	StatAdvisor: Recommending Statistical Views	2009	VLDB	6.1901666e-05
5,659	POP/FED: Progressive Query Optimization for Federated Queries in DB2	2006	VLDB	6.1311315e-05
7,377	Efficient and Scalable Statistics Gathering for Large Databases in Oracle 11g	2008	SIGMOD	5.6297042e-05
8,494	POLAR: Adaptive and Non-invasive Join Order Selection via Plans of Least Resistance	2024	VLDB	5.4142129e-05
9,671	Detecting Attribute Dependencies from Query Feedback	2007	VLDB	5.238674e-05
12,258	Statistics Collection in Oracle Spatial and Graph: Fast Histogram Construction for Complex Geometry Objects	2013	VLDB	5.093636e-05
13,857	Automated Statistics Collection in Action	2005	SIGMOD	-

Outgoing Citations (Sorted by Pagerank)

Showing 7 of 7 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
35	Improved Histograms for Selectivity Estimation of Range Predicates	1996	SIGMOD	0.00048481081
100	LEO - DB2's LEarning Optimizer	2001	VLDB	0.00034385207
159	CORDS: Automatic Discovery of Correlations and Soft Functional Dependencies	2004	SIGMOD	0.00028129426
365	STHoles: A Multidimensional Workload-Aware Histogram	2001	SIGMOD	0.00020041735
448	Self-tuning Histograms: Building Histograms Without Looking at Data	1999	SIGMOD	0.00018292618
664	Exploiting Statistics on Query Expressions for Optimization	2002	SIGMOD	0.00015167825
2,121	SASH: A Self-Adaptive Histogram Set for Dynamically Changing Workloads	2003	VLDB	9.1402718e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	6,700	Self-Managing Technology in Database Management Systems	2004	VLDB
2	461	Query-based Workload Forecasting for Self-Driving Database Management Systems	2018	SIGMOD
3	7,770	Automated design of multidimensional clustering tables for relational databases	2004	VLDB
4	6,131	Foundations of Automated Database Tuning	2006	VLDB
5	6,779	O-O, What Have They Done to DB2?	1999	VLDB
6	184	DB2 Design Advisor: Integrated Automatic Physical Database Design	2004	VLDB
7	4,277	Adaptive Statistics in Oracle 12c	2017	VLDB
8	6,562	Query Sampling in DB2 Universal Database	2004	SIGMOD
9	8,460	Maintenance of Cube Automatic Summary Tables	2000	SIGMOD
10	13,857	Automated Statistics Collection in Action	2005	SIGMOD