Sign in Subscribe
Share

Optimizing Join and Aggregation with Teradata UNION ALL Views

Teradata 16 introduces a new option for handling sets of rows combined with "UNION ALL" in views and derived tables, reducing resource usage. The optimizer can apply aggregation steps and join operations to each branch of the "UNION ALL" separately, resulting in smaller spool sizes and improved perf

Optimizing Join and Aggregation with Teradata UNION ALL Views
sql1

This post is for subscribers only

Already have an account? Sign in.

Subscribe to DWHPro Letters

Practical field notes on enterprise data engineering, production AI systems, platform migration, and the senior engineering market.
Written by Roland Wenzlofsky Founder of DWHPro Author of Teradata Query Performance Tuning
Get the next issue
Subscribe