Adaptive Statistics in Oracle 12c

Summary: Oracle 12c tackles optimizer errors from inaccurate intermediate-result cardinalities. It automatically validates estimates and builds auxiliary statistics on demand, using sampling and caching to limit overhead, with gains shown on IMDB and customer workloads. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: h7bab7628844c96e2
Venue: VLDB
Year: 2017
Pagerank: 6.7104002e-05
Overall Rank: 4,234 | 71.55%
DOI: 10.14778/3137765.3137771
PDF: Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

1. Sunil Chakkappen (Oracle)
2. Suratna Budalakoti (Oracle)
3. Ramarajan Krishnamachari (Oracle)
4. Satyanarayana R Valluri (Oracle)
5. Alan Wood (Oracle)
6. Mohamed Zait (Oracle)

BibTeX Citation

@article{chakkappen_vldb17,
        title = {{Adaptive Statistics in Oracle 12c}},
        author = {Chakkappen, Sunil and Budalakoti, Suratna and Krishnamachari, Ramarajan and Valluri, Satyanarayana R and Wood, Alan and Zait, Mohamed},
        journal = {PVLDB},
        series = {{VLDB} '17},
        volume = {10},
        number = {12},
        pages = {1813--1824},
        doi = {10.14778/3137765.3137771},
        url = {https://doi.org/10.14778/3137765.3137771},
        year = {2017}
}

Incoming Citations (Sorted by Pagerank)

Showing 8 of 8 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,065	Are We Ready For Learned Cardinality Estimation?	2021	VLDB	0.00012202293
1,543	Improved Selectivity Estimation by Combining Knowledge from Sampling and Synopses	2018	VLDB	0.00010305662
3,132	Every Row Counts: Combining Sketches and Sampling for Accurate Group-By Result Estimates	2019	CIDR	7.6107287e-05
3,446	Apache Hive: From MapReduce to Enterprise-grade Big Data Warehousing	2019	SIGMOD	7.2908619e-05
9,640	Small Selectivities Matter: Lifting the Burden of Empty Samples	2021	SIGMOD	5.1448486e-05
10,937	Real-time SQL Plan Management in Oracle	2026	VLDB	4.9769913e-05
10,950	Ultron: History-Based Query Optimization at Databricks	2026	VLDB	4.9769913e-05
11,957	Index-Based Join Size Estimation Using Adaptive Sampling	2021	SIGMOD	4.9769913e-05

Outgoing Citations (Sorted by Pagerank)

Showing 11 of 11 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
15	How Good Are Query Optimizers, Really?	2016	VLDB	0.00061067652
98	LEO - DB2's LEarning Optimizer	2001	VLDB	0.00034099838
386	Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors	2009	VLDB	0.00019446558
529	Automatic SQL Tuning in Oracle 10g	2004	VLDB	0.00016859276
749	Join Size Estimation Subject to Filter Conditions	2015	VLDB	0.00014261044
1,258	Sampling-Based Query Re-Optimization	2016	SIGMOD	0.00011308863
1,743	Combining Histograms and Parametric Curve Fitting for Feedback-Driven Query Result-Size Estimation	1999	VLDB	9.7342409e-05
3,134	Statistics on Views	2003	VLDB	7.6093829e-05
4,711	Optimizer Plan Change Management: Improved Stability and Performance in Oracle 11g	2008	VLDB	6.4550597e-05
5,447	Closing The Query Processing Loop in Oracle 11g	2008	VLDB	6.1243173e-05
5,598	StatAdvisor: Recommending Statistical Views	2009	VLDB	6.0690976e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	4,711	Optimizer Plan Change Management: Improved Stability and Performance in Oracle 11g	2008	VLDB
2	7,515	Efficient and Scalable Statistics Gathering for Large Databases in Oracle 11g	2008	SIGMOD
3	5,598	StatAdvisor: Recommending Statistical Views	2009	VLDB
4	5,983	Supporting Time-Constrained SQL Queries in Oracle	2007	VLDB
5	682	Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques	2012	VLDB
6	529	Automatic SQL Tuning in Oracle 10g	2004	VLDB
7	149	Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans	1998	SIGMOD
8	644	Exploiting Statistics on Query Expressions for Optimization	2002	SIGMOD
9	5,447	Closing The Query Processing Loop in Oracle 11g	2008	VLDB
10	4,258	Query Optimization in Oracle 12c Database In-Memory	2015	VLDB