Joins over UNION ALL Queries in Teradata®: Demonstration of Optimized Execution
Summary: Demonstrates cost-based optimization for joins over UNION ALL views. Replaces spooling with: pushing joins into UNION ALL branches, geography-aware redistribution, iterative join decomposition, and a multisource join step; Visual Explain support. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
No non-self incoming citations found for this paper in this database.
Authors
- 1. Mohammed Al-Kateb (Teradata)
- 2. Paul Sinclair (Teradata)
- 3. Grace Au (Teradata)
- 4. Sanjay Nair (Teradata)
- 5. Mark Sirek (Teradata)
- 6. Lu Ma (Teradata)
- 7. Mohamed Y. Eltabakh (Teradata)
BibTeX Citation
@inproceedings{alkateb_sigmod18,
title = {{Joins over UNION ALL Queries in Teradata®: Demonstration of Optimized Execution}},
author = {Al-Kateb, Mohammed and Sinclair, Paul and Au, Grace and Nair, Sanjay and Sirek, Mark and Ma, Lu and Eltabakh, Mohamed Y.},
series = {{SIGMOD} '18},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/3183713.3193565},
url = {https://dl.acm.org/doi/10.1145/3183713.3193565},
year = {2018}
}Incoming Citations (Sorted by Pagerank)
Showing 0 of 0 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 2 of 2 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 3,199 | Query Optimization Techniques for Partitioned Tables | 2011 | SIGMOD | 7.6423984e-05 |
| 6,984 | Evolving Teradata Decision Support for Massively Parallel Processing with UNIX | 1994 | SIGMOD | 5.7303405e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 13,231 | Using Semiouterjoins to Process Queries in Multidatabase Systems | 1984 | PODS |
| 2 | 5,882 | Heterogeneous Database Query Optimization in DB2 Universal DataJoiner | 1998 | VLDB |
| 3 | 5,364 | Fast Join Project Query Evaluation using Matrix Multiplication | 2020 | SIGMOD |
| 4 | 1,740 | Adopting Worst-Case Optimal Joins in Relational Database Systems | 2020 | VLDB |
| 5 | 2,244 | Join Queries with External Text Sources: Execution and Optimization Techniques | 1995 | SIGMOD |
| 6 | 1,022 | A Scalable, Predictable Join Operator for Highly Concurrent Data Warehouses | 2009 | VLDB |
| 7 | 1,320 | From Theory to Practice: Efficient Join Query Evaluation in a Parallel Database System | 2015 | SIGMOD |
| 8 | 11,297 | Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle | 2024 | VLDB |
| 9 | 3,134 | Efficient Join Algorithms For Large Database Tables in a Multi-GPU Environment | 2021 | VLDB |
| 10 | 2,104 | Optimization of Multi-Way Join Queries for Parallel Execution | 1991 | VLDB |