Debunking the Myth of Join Ordering: Toward Robust SQL Analytics
Summary: Robust Predicate Transfer (RPT) for acyclic joins; introduces LargestRoot and SafeSubjoin to achieve provable robustness to arbitrary join orders. Implemented in DuckDB; evaluated on TPC-H/JOB/TPC-DS/DSB, delivering up to 1.6x robustness improvement and ~1.5x end-to-end speedup. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Junyi Zhao (Tsinghua University)
- 2. Kai Su (Tsinghua University)
- 3. Yifei Yang (University of Wisconsin)
- 4. Xiangyao Yu (University of Wisconsin)
- 5. Paraschos Koutris (University of Wisconsin)
- 6. Huanchen Zhang (Shanghai Qi Zhi Institute; Tsinghua University)
BibTeX Citation
@inproceedings{zhao_sigmod25,
title = {{Debunking the Myth of Join Ordering: Toward Robust SQL Analytics}},
author = {Zhao, Junyi and Su, Kai and Yang, Yifei and Yu, Xiangyao and Koutris, Paraschos and Zhang, Huanchen},
series = {{SIGMOD} '25},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/3725283},
url = {https://dl.acm.org/doi/10.1145/3725283},
year = {2025}
}
Incoming Citations (Sorted by Pagerank)
Showing 17 of 17 citing papers.
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 1 of 51 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 10,304 | Data Chunk Compaction in Vectorized Execution | 2025 | SIGMOD | 5.0400722e-05 |
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 12,209 | Improving Join Reorderability with Compensation Operators | 2018 | SIGMOD |
| 2 | 884 | Dynamic Programming Strikes Back | 2008 | SIGMOD |
| 3 | 8,039 | Efficiently Computing Join Orders with Heuristic Search | 2023 | SIGMOD |
| 4 | 1,596 | Adopting Worst-Case Optimal Joins in Relational Database Systems | 2020 | VLDB |
| 5 | 6,545 | Ranked Enumeration of Join Queries with Projections | 2022 | VLDB |
| 6 | 10,768 | One Join Order Does Not Fit All: Reducing Intermediate Results with Per-Split Query Plans | 2026 | VLDB |
| 7 | 3,797 | Query Simplification: Graceful Degradation for Join-Order Optimization | 2009 | SIGMOD |
| 8 | 3,982 | Simplicity Done Right for Join Ordering | 2021 | CIDR |
| 9 | 3,153 | Robust Join Processing with Diamond Hardened Joins | 2024 | VLDB |
| 10 | 10,713 | Robust Predicate Transfer with Dynamic Execution | 2026 | VLDB |