Database Paper Browser

Back to papers

Towards a Hands-Free Query Optimizer through Deep Learning

Summary: Vision to replace heuristic, hand-tuned optimizers with end-to-end deep RL agents that learn plan search, cost estimation, and operator choices, reducing manual tuning. Paper analyzes deployment challenges (exploration, reward sparsity, generalization) and sketches three DL approaches. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID
342
Venue
CIDR
Year
2019
Pagerank
6.8704209e-05
Overall Rank
3,658 | 74.56%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 19 of 19 citing papers.

Rank Citing Paper Year Venue Pagerank
333 Neo: A Learned Query Optimizer 2019 VLDB 0.00027206884
884 Plan-Structured Deep Neural Network Models for Query Performance Prediction 2019 VLDB 0.00015654004
2,139 Diagnosing Root Causes of Intermittent Slow Queries in Cloud Databases 2020 VLDB 9.4640037e-05
2,552 Updatable Learned Index with Precise Positions 2021 VLDB 8.5530411e-05
2,596 WeTune: Automatic Discovery and Verification of Query Rewrite Rules 2022 SIGMOD 8.4729982e-05
2,783 Flow-Loss: Learning Cardinality Estimates That Matter 2021 VLDB 8.1293383e-05
3,725 Estimating Cardinalities with Deep Sketches 2019 SIGMOD 6.8170734e-05
3,779 Instance-Optimized Data Layouts for Cloud Analytics Workloads 2021 SIGMOD 6.7747205e-05
4,388 Proving Query Equivalence Using Linear Integer Arithmetic 2023 SIGMOD 6.2303078e-05
4,646 CARMI: A Cache-Aware Learned Index with a Cost-based Construction Algorithm 2022 VLDB 6.0250374e-05
4,804 Efficient Deep Learning Pipelines for Accurate Cost Estimations Over Large Scale Query Workload 2021 SIGMOD 5.910467e-05
5,423 Kepler: Robust Learning for Faster Parametric Query Optimization 2023 SIGMOD 5.5130233e-05
5,924 HMAB: Self-Driving Hierarchy of Bandits for Integrated Physical Database Design Tuning 2023 VLDB 5.2719183e-05
6,456 From Auto-tuning One Size Fits All to Self-designed and Learned Data-intensive Systems 2019 SIGMOD 5.0564619e-05
7,008 Is Your Learned Query Optimizer Behaving As You Expect? A Machine Learning Perspective 2024 VLDB 4.8643538e-05
8,127 Robust Query Processing: Mission Possible 2020 VLDB 4.579056e-05
8,774 Tiresias: Enabling Predictive Autonomous Storage and Indexing 2022 VLDB 4.4559995e-05
9,819 Generating Application-Specific Data Layouts for In-memory Databases 2019 VLDB 4.2774401e-05
10,018 GenJoin: Conditional Generative Plan-to-Plan Query Optimizer that Learns from Subplan Hints 2026 SIGMOD 4.1945683e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 8 of 8 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
102 The Case for Learned Index Structures 2018 SIGMOD 0.00049545203
182 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00036962631
252 Adaptive Selectivity Estimation Using Query Feedback 1994 SIGMOD 0.00030632263
300 Deep Learning for Entity Matching: A Design Space Exploration 2018 SIGMOD 0.00028441466
359 Self-Driving Database Management Systems 2017 CIDR 0.0002592783
529 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD 0.00020828852
684 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00018179769
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
7,470 The Case for Deep Query Optimisation 2020 CIDR 4.7201897e-05
2,364 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD 8.9554751e-05
8,659 Learned Offline Query Planning via Bayesian Optimization 2025 SIGMOD 4.4722928e-05
608 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00019235898
884 Plan-Structured Deep Neural Network Models for Query Performance Prediction 2019 VLDB 0.00015654004
11,318 Can Transfer Learning be used to build a Query Optimizer? 2022 CIDR 4.1945683e-05
11,350 DeepO: A Learned Query Optimizer 2022 SIGMOD 4.1945683e-05
7,008 Is Your Learned Query Optimizer Behaving As You Expect? A Machine Learning Perspective 2024 VLDB 4.8643538e-05
5,861 Machine Learning for Databases 2021 VLDB 5.298883e-05
9,120 Deep Query Optimization 2019 SIGMOD 4.392741e-05