DBScholar

Back to papers

AutoSteer: Learned Query Optimization for Any SQL Database

Summary: AutoSteer: a portable, learning-based system that steers any SQL optimizer exposing tunable knobs by extending Bao with automated hint-set discovery and low-integration APIs for monolithic and disaggregated engines. Evaluated on PostgreSQL, Presto, Spark, MySQL and DuckDB, it outperforms native optimizers (up to ~40% for Presto), matches Bao while reducing human supervision, and ships open-source with a visual tool. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID
ha59f57d6e776ecc9
Venue
VLDB
Year
2023
Pagerank
6.4721041e-05
Overall Rank
4,677 | 68.57%
DOI
10.14778/3611540.3611544
PDF
Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{anneser_vldb23,
        title = {{AutoSteer: Learned Query Optimization for Any SQL Database}},
        author = {Anneser, Christoph and Tatbul, Nesime and Cohen, David and Xu, Zhenggang and Pandian, Prithviraj and Laptev, Nikolay and Marcus, Ryan},
        journal = {PVLDB},
        series = {{VLDB} '23},
        volume = {16},
        number = {12},
        pages = {3515--3527},
        doi = {10.14778/3611540.3611544},
        url = {https://doi.org/10.14778/3611540.3611544},
        year = {2023}
}

Incoming Citations (Sorted by Pagerank)

Showing 22 of 22 citing papers.

Rank Citing Paper Year Venue Pagerank
5,700 PilotScope: Steering Databases with Machine Learning Drivers 2024 VLDB 6.028998e-05
7,464 T3: Accurate and Fast Performance Prediction for Relational Database Systems With Compiled Decision Trees 2025 SIGMOD 5.5189616e-05
7,546 Learned Offline Query Planning via Bayesian Optimization 2025 SIGMOD 5.4966669e-05
7,981 The Holon Approach for Simultaneously Tuning Multiple Components in a Self-Driving Database Management System with Machine Learning via Synthesized Proto-Actions 2024 VLDB 5.4117272e-05
8,373 GenJoin: Conditional Generative Plan-to-Plan Query Optimizer that Learns from Subplan Hints 2026 SIGMOD 5.3427119e-05
9,122 Presto’s History-based Query Optimizer 2024 VLDB 5.2251319e-05
9,635 Low Rank Learning for Offline Query Optimization 2025 SIGMOD 5.1453041e-05
9,962 Graph Transformers for Query Plan Representation: Potentials and Challenges 2025 VLDB 5.1014161e-05
10,035 QO-Insight: Inspecting Steered Query Optimizers 2023 VLDB 5.0901047e-05
10,256 AnyBlox: A Framework for Self-Decoding Datasets 2025 VLDB 5.0495724e-05
10,296 This is Going to Sound Crazy, But What If We Used Large Language Models to Boost Automatic Database Tuning Algorithms By Leveraging Prior History? We Will Find Better Configurations More Quickly Than Retraining From Scratch! 2026 SIGMOD 5.0407989e-05
10,319 Intra-Query Runtime Elasticity for Cloud-Native Data Analysis 2025 SIGMOD 5.0362412e-05
10,343 An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL 2025 SIGMOD 5.0176429e-05
10,362 Survivorship Bias in Industrial Database Workloads 2026 CIDR 4.9769913e-05
10,690 Reqo: A Comprehensive Learning-Based Cost Model for Robust and Explainable Query Optimization 2026 SIGMOD 4.9769913e-05
10,751 OBELISK: Efficient Offline Query Planning with Bayesian Optimization-Informed Language Model Reasoning 2026 VLDB 4.9769913e-05
10,933 TATA: An Efficient Framework for Task Transfer in Query Plan Representation 2026 VLDB 4.9769913e-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,246 PlanRGCN: Predicting SPARQL Query Performance 2025 VLDB 4.9769913e-05
11,381 GRewriter: Practical Query Rewriting with Automatic Rule Set Expansion in GaussDB 2025 VLDB 4.9769913e-05
11,439 CloudGlide: Deconstructing the Landscape of Cloud-Based Analytics 2025 VLDB 4.9769913e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 23 of 23 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
23 Spark SQL: Relational Data Processing in Spark 2015 SIGMOD 0.00055384955
85 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035876108
144 Neo: A Learned Query Optimizer 2019 VLDB 0.00029090793
318 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00021166957
361 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00020000855
379 Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources 2018 SIGMOD 0.00019507406
510 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017059914
950 Lakehouse: A New Generation of Open Platforms that Unify Data Warehousing and Advanced Analytics 2021 CIDR 0.00012889569
1,065 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012202293
1,195 Balsa: Learning a Query Optimizer Without Expert Demonstrations 2022 SIGMOD 0.00011574218
1,277 Orca: A Modular Query Optimizer Architecture for Big Data 2014 SIGMOD 0.00011234276
1,735 Flow-Loss: Learning Cardinality Estimates That Matter 2021 VLDB 9.7566604e-05
2,342 Learned Cardinality Estimation: An In-depth Study 2022 SIGMOD 8.6074783e-05
2,393 A Learned Query Rewrite System using Monte Carlo Tree Search 2022 VLDB 8.5298464e-05
2,518 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 8.3532841e-05
2,686 Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection 2022 VLDB 8.1300913e-05
2,770 Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation 2022 VLDB 8.0343719e-05
3,948 Deploying a Steered Query Optimizer in Production at Microsoft 2022 SIGMOD 6.9051584e-05
4,536 One Model to Rule them All: Towards Zero-Shot Learning for Databases 2022 CIDR 6.552998e-05
5,110 Steering Query Optimizers: A Practical Take on Big Data Workloads 2021 SIGMOD 6.2678118e-05
5,777 POP/FED: Progressive Query Optimization for Federated Queries in DB2 2006 VLDB 5.9953732e-05
10,035 QO-Insight: Inspecting Steered Query Optimizers 2023 VLDB 5.0901047e-05
Previous Page 1 / 1 Next

Semantically Similar Papers