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: 7322
Venue: SIGMOD
Year: 2026
Pagerank: 4.1945683e-05
Overall Rank: 10,018 | 30.31%
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.00059038975
115	Eddies: Continuously Adaptive Query Processing	2000	SIGMOD	0.00046221215
204	Learned Cardinalities: Estimating Correlated Joins with Deep Learning	2019	CIDR	0.00034784455
333	Neo: A Learned Query Optimizer	2019	VLDB	0.00027206884
608	DeepDB: Learn from Data, not from Queries!	2020	VLDB	0.00019235898
640	Bao: Making Learned Query Optimization Practical	2021	SIGMOD	0.00018759152
910	NeuroCard: One Cardinality Estimator for All Tables	2021	VLDB	0.00015423056
2,121	Balsa: Learning a Query Optimizer Without Expert Demonstrations	2022	SIGMOD	9.5017232e-05
2,762	FLAT: Fast, Lightweight and Accurate Method for Cardinality Estimation	2021	VLDB	8.1585394e-05
3,169	QueryFormer: A Tree Transformer Model for Query Plan Representation	2022	VLDB	7.4498425e-05
3,348	Lero: A Learning-to-Rank Query Optimizer	2023	VLDB	7.1904529e-05
3,499	Fauce: Fast and Accurate Deep Ensembles with Uncertainty for Cardinality Estimation	2021	VLDB	7.0376445e-05
3,658	Towards a Hands-Free Query Optimizer through Deep Learning	2019	CIDR	6.8704209e-05
3,727	Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection	2022	VLDB	6.8141709e-05
3,828	Zero-Shot Cost Models for Out-of-the-box Learned Cost Prediction	2022	VLDB	6.7208524e-05
3,990	FactorJoin: A New Cardinality Estimation Framework for Join Queries	2023	SIGMOD	6.5581983e-05
4,462	LOGER: A Learned Optimizer towards Generating Efficient and Robust Query Execution Plans	2023	VLDB	6.1611784e-05
5,334	LEON: A New Framework for ML-Aided Query Optimization	2023	VLDB	5.5649836e-05
5,640	AutoSteer: Learned Query Optimization for Any SQL Database	2023	VLDB	5.3933314e-05
5,930	FASTgres: Making Learned Query Optimizer Hinting Effective	2023	VLDB	5.2682075e-05
5,952	Eraser: Eliminating Performance Regression on Learned Query Optimizer	2024	VLDB	5.2591691e-05
6,383	Sample-Efficient Cardinality Estimation Using Geometric Deep Learning	2024	VLDB	5.0884322e-05
6,885	PilotScope: Steering Databases with Machine Learning Drivers	2024	VLDB	4.895386e-05
7,008	Is Your Learned Query Optimizer Behaving As You Expect? A Machine Learning Perspective	2024	VLDB	4.8643538e-05
8,220	PerfGuard: Deploying ML-for-Systems without Performance Regressions, Almost!	2021	VLDB	4.5557328e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
6,056	Efficient Massively Parallel Join Optimization for Large Queries*	2022	SIGMOD	5.2321475e-05
8,488	Can Large Language Models Be Query Optimizer for Relational Databases?	2026	SIGMOD	4.4998609e-05
1,619	Adaptive Optimization of Very Large Join Queries	2018	SIGMOD	0.00011111678
7,011	Simple Adaptive Query Processing vs. Learned Query Optimizers: Observations and Analysis	2023	VLDB	4.8629458e-05
7,008	Is Your Learned Query Optimizer Behaving As You Expect? A Machine Learning Perspective	2024	VLDB	4.8643538e-05
10,880	RankPQO: Learning-to-Rank for Parametric Query Optimization	2025	VLDB	4.1945683e-05
5,371	LearnedSQLGen: Constraint-aware SQL Generation using Reinforcement Learning	2022	SIGMOD	5.5428776e-05
3,474	Solving the Join Ordering Problem via Mixed Integer Linear Programming	2017	SIGMOD	7.0625972e-05
9,662	Efficient Query Re-optimization with Judicious Subquery Selections	2023	SIGMOD	4.3097631e-05
3,727	Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection	2022	VLDB	6.8141709e-05