DWHPro helps thousands of visitors every month to become experts in Teradata and data warehouse design and operations by Roland Wenzlofsky

All issues

Teradata UNION ALL Views for Faster Joins

A different way to handle rows combined with UNION ALL in views and derived tables, and the…

From the DWHPro archive

Optimizing Join and Aggregation with Teradata UNION ALL Views

A different way to handle rows combined with UNION ALL in views and derived tables, and the resources it saves.

Read the article →

Also worth reading: Teradata SQL Tuning and Query Rewriting

— Roland


Written by Roland Wenzlofsky — 25 years on enterprise data platforms, author of Teradata Query Performance Tuning.

Reply to this email if you think I am wrong. I read every reply.

I work with senior freelance data engineers on enterprise migrations. If that is you, here is what that looks like.


You are receiving this because you subscribed to the DWHPro newsletter.
Unsubscribe

Share
Get the next issue in your inbox
Free, and you can unsubscribe any time.

0 comments

More issues

All 74 →
#70 Sep 17, 2026

Understanding Teradata Hash Collisions - A Case Study

Read issue →
#69 Sep 15, 2026

Export Teradata to CSV: Fast Multi-File Export

Read issue →