Adaptive Statistics in Oracle 12c
Summary: Oracle 12c introduces adaptive statistics to reduce intermediate-result errors. It validates stats against table data, auto-creates auxiliary statistics, caches results, and uses sampling to limit overhead, with IMDB-like workloads showing gains. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
Incoming Citations (Sorted by Pagerank)
Showing 6 of 6 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,699 | Are We Ready For Learned Cardinality Estimation? | 2021 | VLDB | 0.00010848882 |
| 1,978 | Improved Selectivity Estimation by Combining Knowledge from Sampling and Synopses | 2018 | VLDB | 9.8764627e-05 |
| 3,706 | Every Row Counts: Combining Sketches and Sampling for Accurate Group-By Result Estimates | 2019 | CIDR | 6.8232992e-05 |
| 3,966 | Apache Hive: From MapReduce to Enterprise-grade Big Data Warehousing | 2019 | SIGMOD | 6.5782437e-05 |
| 9,387 | Small Selectivities Matter: Lifting the Burden of Empty Samples | 2021 | SIGMOD | 4.341968e-05 |
| 11,449 | Index-Based Join Size Estimation Using Adaptive Sampling | 2021 | SIGMOD | 4.1905499e-05 |
Previous
Page 1 / 1
Next
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 |
|---|---|---|---|---|
| 71 | How Good Are Query Optimizers, Really? | 2016 | VLDB | 0.00059446482 |
| 181 | LEO - DB2's LEarning Optimizer | 2001 | VLDB | 0.00036970794 |
| 495 | Automatic SQL Tuning in Oracle 10g | 2004 | VLDB | 0.00021712703 |
| 627 | Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors | 2009 | VLDB | 0.00018959896 |
| 1,194 | Join Size Estimation Subject to Filter Conditions | 2015 | VLDB | 0.00013411666 |
| 1,691 | Combining Histograms and Parametric Curve Fitting for Feedback-Driven Query Result-Size Estimation | 1999 | VLDB | 0.00010890775 |
| 1,756 | Sampling-Based Query Re-Optimization | 2016 | SIGMOD | 0.00010659753 |
| 3,398 | Statistics on Views | 2003 | VLDB | 7.1381433e-05 |
| 4,513 | Optimizer Plan Change Management: Improved Stability and Performance in Oracle 11g | 2008 | VLDB | 6.1183817e-05 |
| 5,824 | StatAdvisor: Recommending Statistical Views | 2009 | VLDB | 5.311975e-05 |
| 6,142 | Closing The Query Processing Loop in Oracle 11g | 2008 | VLDB | 5.186791e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 4,513 | Optimizer Plan Change Management: Improved Stability and Performance in Oracle 11g | 2008 | VLDB | 6.1183817e-05 |
| 7,414 | Efficient and Scalable Statistics Gathering for Large Databases in Oracle 11g | 2008 | SIGMOD | 4.7312542e-05 |
| 5,824 | StatAdvisor: Recommending Statistical Views | 2009 | VLDB | 5.311975e-05 |
| 5,547 | Supporting Time-Constrained SQL Queries in Oracle | 2007 | VLDB | 5.4452585e-05 |
| 1,017 | Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques | 2012 | VLDB | 0.00014627121 |
| 495 | Automatic SQL Tuning in Oracle 10g | 2004 | VLDB | 0.00021712703 |
| 221 | Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans | 1998 | SIGMOD | 0.00033182072 |
| 786 | Exploiting Statistics on Query Expressions for Optimization | 2002 | SIGMOD | 0.00016624743 |
| 6,142 | Closing The Query Processing Loop in Oracle 11g | 2008 | VLDB | 5.186791e-05 |
| 5,184 | Query Optimization in Oracle 12c Database In-Memory | 2015 | VLDB | 5.6360141e-05 |