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
13371
Venue
VLDB
Year
2023
Pagerank
6.4423294e-05
Overall Rank
4,929 | 66.19%
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 20 of 20 citing papers.

Rank Citing Paper Year Venue Pagerank
6,462 PilotScope: Steering Databases with Machine Learning Drivers 2024 VLDB 5.8717744e-05
7,846 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.5331459e-05
8,163 Learned Offline Query Planning via Bayesian Optimization 2025 SIGMOD 5.4751517e-05
8,572 T3: Accurate and Fast Performance Prediction for Relational Database Systems With Compiled Decision Trees 2025 SIGMOD 5.4102362e-05
9,601 Low Rank Learning for Offline Query Optimization 2025 SIGMOD 5.2487799e-05
9,846 QO-Insight: Inspecting Steered Query Optimizers 2023 VLDB 5.2094004e-05
10,057 AnyBlox: A Framework for Self-Decoding Datasets 2025 VLDB 5.1664022e-05
10,108 An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL 2025 SIGMOD 5.1347137e-05
10,128 Survivorship Bias in Industrial Database Workloads 2026 CIDR 5.093636e-05
10,316 GenJoin: Conditional Generative Plan-to-Plan Query Optimizer that Learns from Subplan Hints 2026 SIGMOD 5.093636e-05
10,492 Reqo: A Comprehensive Learning-Based Cost Model for Robust and Explainable Query Optimization 2026 SIGMOD 5.093636e-05
10,506 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.093636e-05
10,559 OBELISK: Efficient Offline Query Planning with Bayesian Optimization-Informed Language Model Reasoning 2026 VLDB 5.093636e-05
10,586 TATA: An Efficient Framework for Task Transfer in Query Plan Representation 2026 VLDB 5.093636e-05
10,768 Intra-Query Runtime Elasticity for Cloud-Native Data Analysis 2025 SIGMOD 5.093636e-05
10,830 PlanRGCN: Predicting SPARQL Query Performance 2025 VLDB 5.093636e-05
11,007 GRewriter: Practical Query Rewriting with Automatic Rule Set Expansion in GaussDB 2025 VLDB 5.093636e-05
11,076 CloudGlide: Deconstructing the Landscape of Cloud-Based Analytics 2025 VLDB 5.093636e-05
11,083 Graph Transformers for Query Plan Representation: Potentials and Challenges 2025 VLDB 5.093636e-05
11,290 Presto’s History-based Query Optimizer 2024 VLDB 5.093636e-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
18 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059284255
24 Spark SQL: Relational Data Processing in Spark 2015 SIGMOD 0.00054865648
84 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035838391
154 Neo: A Learned Query Optimizer 2019 VLDB 0.00028726181
323 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00021264788
378 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00019638121
445 Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources 2018 SIGMOD 0.00018336751
513 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017190574
1,061 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012369764
1,138 Lakehouse: A New Generation of Open Platforms that Unify Data Warehousing and Advanced Analytics 2021 CIDR 0.00012023643
1,241 Balsa: Learning a Query Optimizer Without Expert Demonstrations 2022 SIGMOD 0.00011521639
1,621 Orca: A Modular Query Optimizer Architecture for Big Data 2014 SIGMOD 0.00010203114
1,876 Flow-Loss: Learning Cardinality Estimates That Matter 2021 VLDB 9.5717543e-05
2,452 A Learned Query Rewrite System using Monte Carlo Tree Search 2022 VLDB 8.5584e-05
2,543 Learned Cardinality Estimation: An In-depth Study 2022 SIGMOD 8.4445934e-05
2,723 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 8.2049453e-05
2,740 Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation 2022 VLDB 8.1855759e-05
2,762 Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection 2022 VLDB 8.1539867e-05
3,998 Deploying a Steered Query Optimizer in Production at Microsoft 2022 SIGMOD 6.9676473e-05
4,468 One Model to Rule them All: Towards Zero-Shot Learning for Databases 2022 CIDR 6.6819041e-05
5,059 Steering Query Optimizers: A Practical Take on Big Data Workloads 2021 SIGMOD 6.3807509e-05
5,659 POP/FED: Progressive Query Optimization for Federated Queries in DB2 2006 VLDB 6.1311315e-05
9,846 QO-Insight: Inspecting Steered Query Optimizers 2023 VLDB 5.2094004e-05
Previous Page 1 / 1 Next

Semantically Similar Papers