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.8700949e-05
Overall Rank
3,658 | 74.58%
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
329 Neo: A Learned Query Optimizer 2019 VLDB 0.00027301488
876 Plan-Structured Deep Neural Network Models for Query Performance Prediction 2019 VLDB 0.00015660534
2,140 Diagnosing Root Causes of Intermittent Slow Queries in Cloud Databases 2020 VLDB 9.4565836e-05
2,550 Updatable Learned Index with Precise Positions 2021 VLDB 8.5569576e-05
2,595 WeTune: Automatic Discovery and Verification of Query Rewrite Rules 2022 SIGMOD 8.4725961e-05
2,781 Flow-Loss: Learning Cardinality Estimates That Matter 2021 VLDB 8.1282042e-05
3,725 Estimating Cardinalities with Deep Sketches 2019 SIGMOD 6.8117015e-05
3,777 Instance-Optimized Data Layouts for Cloud Analytics Workloads 2021 SIGMOD 6.7713324e-05
4,385 Proving Query Equivalence Using Linear Integer Arithmetic 2023 SIGMOD 6.2247394e-05
4,800 Efficient Deep Learning Pipelines for Accurate Cost Estimations Over Large Scale Query Workload 2021 SIGMOD 5.9077188e-05
4,830 CARMI: A Cache-Aware Learned Index with a Cost-based Construction Algorithm 2022 VLDB 5.8884997e-05
5,412 Kepler: Robust Learning for Faster Parametric Query Optimization 2023 SIGMOD 5.5200608e-05
5,925 HMAB: Self-Driving Hierarchy of Bandits for Integrated Physical Database Design Tuning 2023 VLDB 5.2669029e-05
6,440 From Auto-tuning One Size Fits All to Self-designed and Learned Data-intensive Systems 2019 SIGMOD 5.0546781e-05
7,009 Is Your Learned Query Optimizer Behaving As You Expect? A Machine Learning Perspective 2024 VLDB 4.8597992e-05
8,130 Robust Query Processing: Mission Possible 2020 VLDB 4.5746794e-05
8,714 Tiresias: Enabling Predictive Autonomous Storage and Indexing 2022 VLDB 4.457682e-05
9,818 Generating Application-Specific Data Layouts for In-memory Databases 2019 VLDB 4.2733415e-05
10,018 GenJoin: Conditional Generative Plan-to-Plan Query Optimizer that Learns from Subplan Hints 2026 SIGMOD 4.1905499e-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.00059446482
101 The Case for Learned Index Structures 2018 SIGMOD 0.00049778866
181 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00036970794
250 Adaptive Selectivity Estimation Using Query Feedback 1994 SIGMOD 0.00030640525
293 Deep Learning for Entity Matching: A Design Space Exploration 2018 SIGMOD 0.00028661817
371 Self-Driving Database Management Systems 2017 CIDR 0.00025382677
527 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD 0.00020862475
680 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00018193263
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
7,472 The Case for Deep Query Optimisation 2020 CIDR 4.7156624e-05
2,364 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD 8.955077e-05
606 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00019251186
8,660 Learned Offline Query Planning via Bayesian Optimization 2025 SIGMOD 4.4680058e-05
876 Plan-Structured Deep Neural Network Models for Query Performance Prediction 2019 VLDB 0.00015660534
11,320 Can Transfer Learning be used to build a Query Optimizer? 2022 CIDR 4.1905499e-05
11,352 DeepO: A Learned Query Optimizer 2022 SIGMOD 4.1905499e-05
7,009 Is Your Learned Query Optimizer Behaving As You Expect? A Machine Learning Perspective 2024 VLDB 4.8597992e-05
5,787 Machine Learning for Databases 2021 VLDB 5.3256401e-05
9,117 Deep Query Optimization 2019 SIGMOD 4.3885415e-05