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.4716143e-05
Overall Rank
4,683 | 68.52%
DOI
10.14778/3611540.3611544

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,871 PilotScope: Steering Databases with Machine Learning Drivers 2024 VLDB 5.9639223e-05
7,460 T3: Accurate and Fast Performance Prediction for Relational Database Systems With Compiled Decision Trees 2025 SIGMOD 5.5215755e-05
7,977 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.4142519e-05
8,332 Learned Offline Query Planning via Bayesian Optimization 2025 SIGMOD 5.3528188e-05
9,113 Presto’s History-based Query Optimizer 2024 VLDB 5.2276066e-05
9,300 GenJoin: Conditional Generative Plan-to-Plan Query Optimizer that Learns from Subplan Hints 2026 SIGMOD 5.1987909e-05
9,670 Low Rank Learning for Offline Query Optimization 2025 SIGMOD 5.1452097e-05
9,956 Graph Transformers for Query Plan Representation: Potentials and Challenges 2025 VLDB 5.1038322e-05
10,030 QO-Insight: Inspecting Steered Query Optimizers 2023 VLDB 5.0925155e-05
10,250 AnyBlox: A Framework for Self-Decoding Datasets 2025 VLDB 5.051964e-05
10,290 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.0431863e-05
10,309 Intra-Query Runtime Elasticity for Cloud-Native Data Analysis 2025 SIGMOD 5.0386264e-05
10,336 An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL 2025 SIGMOD 5.0200193e-05
10,350 Survivorship Bias in Industrial Database Workloads 2026 CIDR 4.9793485e-05
10,679 Reqo: A Comprehensive Learning-Based Cost Model for Robust and Explainable Query Optimization 2026 SIGMOD 4.9793485e-05
10,741 OBELISK: Efficient Offline Query Planning with Bayesian Optimization-Informed Language Model Reasoning 2026 VLDB 4.9793485e-05
10,924 TATA: An Efficient Framework for Task Transfer in Query Plan Representation 2026 VLDB 4.9793485e-05
10,928 Real-time SQL Plan Management in Oracle 2026 VLDB 4.9793485e-05
10,941 Ultron: History-Based Query Optimization at Databricks 2026 VLDB 4.9793485e-05
11,238 PlanRGCN: Predicting SPARQL Query Performance 2025 VLDB 4.9793485e-05
11,375 GRewriter: Practical Query Rewriting with Automatic Rule Set Expansion in GaussDB 2025 VLDB 4.9793485e-05
11,433 CloudGlide: Deconstructing the Landscape of Cloud-Based Analytics 2025 VLDB 4.9793485e-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.00061066921
23 Spark SQL: Relational Data Processing in Spark 2015 SIGMOD 0.00055406774
85 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035864347
145 Neo: A Learned Query Optimizer 2019 VLDB 0.0002908188
318 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00021167555
362 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00019989474
379 Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources 2018 SIGMOD 0.00019514689
512 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017050173
950 Lakehouse: A New Generation of Open Platforms that Unify Data Warehousing and Advanced Analytics 2021 CIDR 0.00012895553
1,064 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012202282
1,199 Balsa: Learning a Query Optimizer Without Expert Demonstrations 2022 SIGMOD 0.00011563985
1,276 Orca: A Modular Query Optimizer Architecture for Big Data 2014 SIGMOD 0.00011239266
1,734 Flow-Loss: Learning Cardinality Estimates That Matter 2021 VLDB 9.7545773e-05
2,342 Learned Cardinality Estimation: An In-depth Study 2022 SIGMOD 8.6060437e-05
2,395 A Learned Query Rewrite System using Monte Carlo Tree Search 2022 VLDB 8.5281914e-05
2,522 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 8.3477168e-05
2,690 Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection 2022 VLDB 8.1258173e-05
2,772 Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation 2022 VLDB 8.035288e-05
3,949 Deploying a Steered Query Optimizer in Production at Microsoft 2022 SIGMOD 6.9052796e-05
4,538 One Model to Rule them All: Towards Zero-Shot Learning for Databases 2022 CIDR 6.553705e-05
5,110 Steering Query Optimizers: A Practical Take on Big Data Workloads 2021 SIGMOD 6.269351e-05
5,777 POP/FED: Progressive Query Optimization for Federated Queries in DB2 2006 VLDB 5.9981204e-05
10,030 QO-Insight: Inspecting Steered Query Optimizers 2023 VLDB 5.0925155e-05
Previous Page 1 / 1 Next

Semantically Similar Papers