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,703 | Are We Ready For Learned Cardinality Estimation? | 2021 | VLDB | 0.00010836769 |
| 1,981 | Improved Selectivity Estimation by Combining Knowledge from Sampling and Synopses | 2018 | VLDB | 9.8687545e-05 |
| 3,702 | Every Row Counts: Combining Sketches and Sampling for Accurate Group-By Result Estimates | 2019 | CIDR | 6.8295759e-05 |
| 3,973 | Apache Hive: From MapReduce to Enterprise-grade Big Data Warehousing | 2019 | SIGMOD | 6.5758017e-05 |
| 9,380 | Small Selectivities Matter: Lifting the Burden of Empty Samples | 2021 | SIGMOD | 4.3461329e-05 |
| 11,446 | Index-Based Join Size Estimation Using Adaptive Sampling | 2021 | SIGMOD | 4.1945683e-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.00059038975 |
| 182 | LEO - DB2's LEarning Optimizer | 2001 | VLDB | 0.00036962631 |
| 496 | Automatic SQL Tuning in Oracle 10g | 2004 | VLDB | 0.00021728655 |
| 629 | Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors | 2009 | VLDB | 0.00018942366 |
| 1,193 | Join Size Estimation Subject to Filter Conditions | 2015 | VLDB | 0.00013414989 |
| 1,695 | Combining Histograms and Parametric Curve Fitting for Feedback-Driven Query Result-Size Estimation | 1999 | VLDB | 0.00010882793 |
| 1,758 | Sampling-Based Query Re-Optimization | 2016 | SIGMOD | 0.00010655546 |
| 3,397 | Statistics on Views | 2003 | VLDB | 7.1437062e-05 |
| 4,512 | Optimizer Plan Change Management: Improved Stability and Performance in Oracle 11g | 2008 | VLDB | 6.1241619e-05 |
| 5,815 | StatAdvisor: Recommending Statistical Views | 2009 | VLDB | 5.3165295e-05 |
| 6,139 | Closing The Query Processing Loop in Oracle 11g | 2008 | VLDB | 5.1912675e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 4,512 | Optimizer Plan Change Management: Improved Stability and Performance in Oracle 11g | 2008 | VLDB | 6.1241619e-05 |
| 7,415 | Efficient and Scalable Statistics Gathering for Large Databases in Oracle 11g | 2008 | SIGMOD | 4.7355557e-05 |
| 5,815 | StatAdvisor: Recommending Statistical Views | 2009 | VLDB | 5.3165295e-05 |
| 5,539 | Supporting Time-Constrained SQL Queries in Oracle | 2007 | VLDB | 5.4503121e-05 |
| 1,019 | Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques | 2012 | VLDB | 0.00014625603 |
| 496 | Automatic SQL Tuning in Oracle 10g | 2004 | VLDB | 0.00021728655 |
| 220 | Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans | 1998 | SIGMOD | 0.00033194808 |
| 790 | Exploiting Statistics on Query Expressions for Optimization | 2002 | SIGMOD | 0.0001663283 |
| 6,139 | Closing The Query Processing Loop in Oracle 11g | 2008 | VLDB | 5.1912675e-05 |
| 5,186 | Query Optimization in Oracle 12c Database In-Memory | 2015 | VLDB | 5.6400929e-05 |