DBScholar

Back to papers

Zero-Shot Cost Models for Out-of-the-box Learned Cost Prediction

Summary: Zero-shot cost models deliver out-of-the-box learned cost estimation that generalizes to unseen databases without training queries. A novel architecture and workload encoding enable transfer from pre-trained models, outperforming workload-driven baselines and supporting few-shot refinement on new databases. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h92000e9c0bc6094c
Venue
VLDB
Year
2022
Pagerank
8.1985665e-05
Overall Rank
2,619 | 82.45%
DOI
10.14778/3551793.3551799
PDF
Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{hilprecht_vldb22,
        title = {{Zero-Shot Cost Models for Out-of-the-box Learned Cost Prediction}},
        author = {Hilprecht, Benjamin and Binnig, Carsten},
        journal = {PVLDB},
        series = {{VLDB} '22},
        volume = {15},
        number = {11},
        pages = {2361--2374},
        doi = {10.14778/3551793.3551799},
        url = {https://doi.org/10.14778/3551793.3551799},
        year = {2022}
}

Incoming Citations (Sorted by Pagerank)

Showing 37 of 37 citing papers.

Rank Citing Paper Year Venue Pagerank
605 CAESURA: Language Models as Multi-Modal Query Planners 2024 CIDR 0.00015630219
3,328 Auto-WLM: Machine Learning Enhanced Workload Management in Amazon Redshift 2023 SIGMOD 7.4094448e-05
4,641 How Good are Learned Cost Models, Really? Insights from Query Optimization Tasks 2025 SIGMOD 6.4739208e-05
4,833 Stage: Query Execution Time Prediction in Amazon Redshift 2024 SIGMOD 6.3834856e-05
5,457 Sample-Efficient Cardinality Estimation Using Geometric Deep Learning 2024 VLDB 6.1058928e-05
6,158 Rethinking Learned Cost Models: Why Start from Scratch? 2023 SIGMOD 5.8518237e-05
7,363 Blueprinting the Cloud: Unifying and Automatically Optimizing Cloud Data Infrastructures with BRAD 2024 VLDB 5.5279826e-05
7,388 Towards Foundation Database Models 2025 CIDR 5.5211011e-05
7,432 POLAR: Adaptive and Non-invasive Join Order Selection via Plans of Least Resistance 2024 VLDB 5.5133928e-05
7,483 T3: Accurate and Fast Performance Prediction for Relational Database Systems With Compiled Decision Trees 2025 SIGMOD 5.5007125e-05
7,561 Learned Offline Query Planning via Bayesian Optimization 2025 SIGMOD 5.4784915e-05
8,389 GenJoin: Conditional Generative Plan-to-Plan Query Optimizer that Learns from Subplan Hints 2026 SIGMOD 5.3250456e-05
8,657 LIMAO: A Framework for Lifelong Modular Learned Query Optimization 2025 VLDB 5.2790784e-05
9,011 Improving DBMS Scheduling Decisions with Accurate Performance Prediction on Concurrent Queries 2025 VLDB 5.2238303e-05
9,031 ByteCard: Enhancing ByteDance’s Data Warehouse with Learned Cardinality Estimation 2024 SIGMOD 5.219814e-05
9,041 Optimizing the cloud? Don't train models. Build oracles! 2024 CIDR 5.2183053e-05
9,141 Presto’s History-based Query Optimizer 2024 VLDB 5.2078543e-05
9,143 Check Out the Big Brain on BRAD: Simplifying Cloud Data Processing with Learned Automated Data Meshes 2023 VLDB 5.2074327e-05
9,662 Low Rank Learning for Offline Query Optimization 2025 SIGMOD 5.1283524e-05
9,829 Wii: Dynamic Budget Reallocation In Index Tuning 2024 SIGMOD 5.1066866e-05
9,995 Graph Transformers for Query Plan Representation: Potentials and Challenges 2025 VLDB 5.0845476e-05
10,257 PRICE: A Pretrained Model for Cross-Database Cardinality Estimation 2025 VLDB 5.039379e-05
10,323 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.0241309e-05
10,370 An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL 2025 SIGMOD 5.0010514e-05
10,391 DQSim: Does the Task Assignment Slow Down Your Distributed Database System? 2027 SIGMOD 4.9605343e-05
10,392 E-LQO: A Comprehensive Energy Evaluation Framework for Learned Query Optimization 2027 SIGMOD 4.9605343e-05
10,393 EASE: Resource-aware Query Scheduling across Heterogeneous Cloud Compute Services 2027 SIGMOD 4.9605343e-05
10,490 Are Learned DBMS Components Robust to Workload Drift?: [Experiments & Analysis] 2026 SIGMOD 4.9605343e-05
10,525 EncoderForge: Generating Efficient SQL for Encoders in Machine Learning Inference Pipelines 2026 SIGMOD 4.9605343e-05
10,676 Understanding and Detecting Query Performance Regression in Practical Index Tuning: [Experiments & Analysis] 2026 SIGMOD 4.9605343e-05
10,751 Reqo: A Comprehensive Learning-Based Cost Model for Robust and Explainable Query Optimization 2026 SIGMOD 4.9605343e-05
10,806 AQD: Online Adaptive Query Dispatcher for HTAP Databases 2026 VLDB 4.9605343e-05
10,812 OBELISK: Efficient Offline Query Planning with Bayesian Optimization-Informed Language Model Reasoning 2026 VLDB 4.9605343e-05
11,142 Libra: One-Shot Parameter Sensitivity Estimation for Transfer Learning in Database Performance Prediction 2026 VLDB 4.9605343e-05
11,288 Esc: An Early-Stopping Checker for Budget-aware Index Tuning 2025 VLDB 4.9605343e-05
11,447 Opening The Black-Box: Explaining Learned Cost Models For Databases 2025 VLDB 4.9605343e-05
11,484 Learned Cost Models for Query Optimization: From Batch to Streaming Systems 2025 VLDB 4.9605343e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 17 of 17 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
84 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035920657
142 Neo: A Learned Query Optimizer 2019 VLDB 0.00029114937
309 An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning 2019 SIGMOD 0.0002143249
320 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00021128745
355 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00020146245
453 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.0001801482
473 The Making of TPC-DS 2006 VLDB 0.00017656775
508 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017108973
545 Plan-Structured Deep Neural Network Models for Query Performance Prediction 2019 VLDB 0.0001657599
676 Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques 2012 VLDB 0.00014838681
1,436 Towards a Learning Optimizer for Shared Clouds 2019 VLDB 0.00010658836
2,481 Learning a Partitioning Advisor for Cloud Databases 2020 SIGMOD 8.3862675e-05
2,768 Query Performance Prediction for Concurrent Queries using Graph Embedding 2020 VLDB 8.0199086e-05
2,828 Cost Models for Big Data Query Processing: Learning, Retrofitting, and Our Findings 2020 SIGMOD 7.9476509e-05
3,967 Efficient Deep Learning Pipelines for Accurate Cost Estimations Over Large Scale Query Workload 2021 SIGMOD 6.8772718e-05
6,113 Expand your Training Limits! Generating Training Data for ML-based Data Management 2021 SIGMOD 5.8662826e-05
10,258 DBMS Fitting: Why should we learn what we already know? 2020 CIDR 5.0391159e-05
Previous Page 1 / 1 Next

Semantically Similar Papers