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 12 of 12 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,662 | Data Chunk Compaction in Vectorized Execution | 2025 | SIGMOD | 5.093636e-05 |
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 12,386 | Efficient Rank Join with Aggregation Constraints | 2011 | VLDB |
| 2 | 11,909 | Improving Join Reorderability with Compensation Operators | 2018 | SIGMOD |
| 3 | 1,013 | Dynamic Programming Strikes Back | 2008 | SIGMOD |
| 4 | 7,882 | Efficiently Computing Join Orders with Heuristic Search | 2023 | SIGMOD |
| 5 | 1,740 | Adopting Worst-Case Optimal Joins in Relational Database Systems | 2020 | VLDB |
| 6 | 6,412 | Ranked Enumeration of Join Queries with Projections | 2022 | VLDB |
| 7 | 3,813 | Query Simplification: Graceful Degradation for Join-Order Optimization | 2009 | SIGMOD |
| 8 | 3,959 | Simplicity Done Right for Join Ordering | 2021 | CIDR |
| 9 | 3,622 | Robust Join Processing with Diamond Hardened Joins | 2024 | VLDB |
| 10 | 10,529 | Robust Predicate Transfer with Dynamic Execution | 2026 | VLDB |