GenJoin: Conditional Generative Plan-to-Plan Query Optimizer that Learns from Subplan Hints

Summary: GenJoin treats optimization as a conditional generative plan-to-plan task, learning from random subplan hints to shrink the search space. Outperforms PostgreSQL and state-of-the-art methods on two real-world benchmarks across diverse workloads, with rigorous ML evaluation. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 7323
Venue: SIGMOD
Year: 2026
Pagerank: 4.1905499e-05
Overall Rank: 10,018 | 30.38%
DOI: 10.1145/3749165

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank

Outgoing Citations (Sorted by Pagerank)

Showing 25 of 25 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
116	Eddies: Continuously Adaptive Query Processing	2000	SIGMOD	0.00046191288
203	Learned Cardinalities: Estimating Correlated Joins with Deep Learning	2019	CIDR	0.00034868567
329	Neo: A Learned Query Optimizer	2019	VLDB	0.00027301488
606	DeepDB: Learn from Data, not from Queries!	2020	VLDB	0.00019251186
634	Bao: Making Learned Query Optimization Practical	2021	SIGMOD	0.00018844568
905	NeuroCard: One Cardinality Estimator for All Tables	2021	VLDB	0.00015423174
2,090	Balsa: Learning a Query Optimizer Without Expert Demonstrations	2022	SIGMOD	9.5668285e-05
2,769	FLAT: Fast, Lightweight and Accurate Method for Cardinality Estimation	2021	VLDB	8.1512848e-05
3,167	QueryFormer: A Tree Transformer Model for Query Plan Representation	2022	VLDB	7.4561078e-05
3,345	Lero: A Learning-to-Rank Query Optimizer	2023	VLDB	7.1908499e-05
3,492	Fauce: Fast and Accurate Deep Ensembles with Uncertainty for Cardinality Estimation	2021	VLDB	7.0435484e-05
3,658	Towards a Hands-Free Query Optimizer through Deep Learning	2019	CIDR	6.8700949e-05
3,729	Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection	2022	VLDB	6.8078013e-05
3,819	Zero-Shot Cost Models for Out-of-the-box Learned Cost Prediction	2022	VLDB	6.7267885e-05
3,992	FactorJoin: A New Cardinality Estimation Framework for Join Queries	2023	SIGMOD	6.5519369e-05
4,464	LOGER: A Learned Optimizer towards Generating Efficient and Robust Query Execution Plans	2023	VLDB	6.1552798e-05
5,339	LEON: A New Framework for ML-Aided Query Optimization	2023	VLDB	5.5596755e-05
5,654	AutoSteer: Learned Query Optimization for Any SQL Database	2023	VLDB	5.3882121e-05
5,931	FASTgres: Making Learned Query Optimizer Hinting Effective	2023	VLDB	5.2632167e-05
5,941	Eraser: Eliminating Performance Regression on Learned Query Optimizer	2024	VLDB	5.2594013e-05
6,382	Sample-Efficient Cardinality Estimation Using Geometric Deep Learning	2024	VLDB	5.0835686e-05
6,883	PilotScope: Steering Databases with Machine Learning Drivers	2024	VLDB	4.8918682e-05
7,009	Is Your Learned Query Optimizer Behaving As You Expect? A Machine Learning Perspective	2024	VLDB	4.8597992e-05
8,219	PerfGuard: Deploying ML-for-Systems without Performance Regressions, Almost!	2021	VLDB	4.551524e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
6,060	Efficient Massively Parallel Join Optimization for Large Queries*	2022	SIGMOD	5.2271244e-05
8,479	Can Large Language Models Be Query Optimizer for Relational Databases?	2026	SIGMOD	4.4967983e-05
1,621	Adaptive Optimization of Very Large Join Queries	2018	SIGMOD	0.00011105663
7,011	Simple Adaptive Query Processing vs. Learned Query Optimizers: Observations and Analysis	2023	VLDB	4.8583284e-05
7,009	Is Your Learned Query Optimizer Behaving As You Expect? A Machine Learning Perspective	2024	VLDB	4.8597992e-05
10,884	RankPQO: Learning-to-Rank for Parametric Query Optimization	2025	VLDB	4.1905499e-05
5,289	LearnedSQLGen: Constraint-aware SQL Generation using Reinforcement Learning	2022	SIGMOD	5.5790771e-05
3,476	Solving the Join Ordering Problem via Mixed Integer Linear Programming	2017	SIGMOD	7.0560383e-05
9,662	Efficient Query Re-optimization with Judicious Subquery Selections	2023	SIGMOD	4.3056334e-05
3,729	Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection	2022	VLDB	6.8078013e-05