Back to papers
Presto’s History-based Query Optimizer
Summary: Records execution histories to predict intermediate cardinalities and operator costs for complex query shapes, replacing brittle analytic estimators. Lightweight, adaptive HBO uses a Redis-backed statistics store to optimize similar future queries and is production-deployed at Meta and Uber.
(summarized by gpt-5-mini on Feb 09 2026)
- Paper ID
- 13608
- Venue
- VLDB
- Year
- 2024
- Pagerank
- 4.1905499e-05
- Overall Rank
- 11,087 | 22.95%
- DOI
-
10.14778/3685800.3685828
Incoming Non-self Citations Over Time
No non-self incoming citations found for this paper in this database.
Incoming Citations (Sorted by Pagerank)
Showing 0 of 0 citing papers.
| Rank |
Citing Paper |
Year |
Venue |
Pagerank |
Outgoing Citations (Sorted by Pagerank)
Showing 24 of 24 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank |
Cited Paper |
Year |
Venue |
Pagerank |
| 70 |
Hive - A Warehousing Solution Over a Map-Reduce Framework |
2009 |
VLDB |
0.00059744625 |
| 71 |
How Good Are Query Optimizers, Really? |
2016 |
VLDB |
0.00059446482 |
| 325 |
The History of Histograms (abridged) |
2003 |
VLDB |
0.00027398081 |
| 329 |
Neo: A Learned Query Optimizer |
2019 |
VLDB |
0.00027301488 |
| 512 |
STHoles: A Multidimensional Workload-Aware Histogram |
2001 |
SIGMOD |
0.00021385343 |
| 634 |
Bao: Making Learned Query Optimization Practical |
2021 |
SIGMOD |
0.00018844568 |
| 1,104 |
Cardinality Estimation Done Right: Index-Based Join Sampling |
2017 |
CIDR |
0.0001398479 |
| 1,638 |
Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation |
2022 |
VLDB |
0.00011050093 |
| 1,699 |
Are We Ready For Learned Cardinality Estimation? |
2021 |
VLDB |
0.00010848882 |
| 2,167 |
Self-Tuning, GPU-Accelerated Kernel Density Models for Multidimensional Selectivity Estimation |
2015 |
SIGMOD |
9.3879598e-05 |
| 2,244 |
Query Optimization in Microsoft SQL Server PDW |
2012 |
SIGMOD |
9.2095696e-05 |
| 2,247 |
Orca: A Modular Query Optimizer Architecture for Big Data |
2014 |
SIGMOD |
9.201975e-05 |
| 3,269 |
Learned Cardinality Estimation: An In-depth Study |
2022 |
SIGMOD |
7.3026051e-05 |
| 3,398 |
Statistics on Views |
2003 |
VLDB |
7.1381433e-05 |
| 3,455 |
Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation |
2022 |
VLDB |
7.0760196e-05 |
| 3,819 |
Zero-Shot Cost Models for Out-of-the-box Learned Cost Prediction |
2022 |
VLDB |
6.7267885e-05 |
| 3,992 |
FactorJoin: A New Cardinality Estimation Framework for Join Queries |
2023 |
SIGMOD |
6.5519369e-05 |
| 4,203 |
Cost Models DO Matter: Providing Cost Information for Diverse Data Sources in a Federated System |
1999 |
VLDB |
6.3561618e-05 |
| 4,513 |
Optimizer Plan Change Management: Improved Stability and Performance in Oracle 11g |
2008 |
VLDB |
6.1183817e-05 |
| 5,537 |
Presto: A Decade of SQL Analytics at Meta |
2023 |
SIGMOD |
5.453017e-05 |
| 5,654 |
AutoSteer: Learned Query Optimization for Any SQL Database |
2023 |
VLDB |
5.3882121e-05 |
| 5,824 |
StatAdvisor: Recommending Statistical Views |
2009 |
VLDB |
5.311975e-05 |
| 7,809 |
Sibyl: Forecasting Time-Evolving Query Workloads |
2024 |
SIGMOD |
4.6415559e-05 |
| 9,205 |
Intelligent Automated Workload Analysis for Database Replatforming |
2022 |
SIGMOD |
4.3698717e-05 |
Semantically Similar Papers
| Overall Rank |
Paper |
Year |
Venue |
Pagerank |
| 9,746 |
Still Asking: How Good Are Query Optimizers, Really? |
2025 |
VLDB |
4.2856385e-05 |
| 5,537 |
Presto: A Decade of SQL Analytics at Meta |
2023 |
SIGMOD |
5.453017e-05 |
| 1,756 |
Sampling-Based Query Re-Optimization |
2016 |
SIGMOD |
0.00010659753 |
| 6,471 |
Leveraging Re-costing for Online Optimization of Parameterized Queries with Guarantees |
2017 |
SIGMOD |
5.0438582e-05 |
| 5,073 |
An Incremental Anytime Algorithm for Multi-Objective Query Optimization |
2015 |
SIGMOD |
5.7118738e-05 |
| 5,012 |
Dynamically Optimizing Queries over Large Scale Data Platforms |
2014 |
SIGMOD |
5.7543101e-05 |
| 3,729 |
Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection |
2022 |
VLDB |
6.8078013e-05 |
| 4,876 |
Approximation Schemes for Many-Objective Query Optimization |
2014 |
SIGMOD |
5.8544467e-05 |
| 680 |
Towards a Robust Query Optimizer: A Principled and Practical Approach |
2005 |
SIGMOD |
0.00018193263 |
| 2,244 |
Query Optimization in Microsoft SQL Server PDW |
2012 |
SIGMOD |
9.2095696e-05 |