DWHPro Insights

join strategy

Achieve Incredible Teradata Join Performance

Illustration of a stopwatch dial on an orange paint-splash background

Executive summaryGUEST POST BY ARTEMIY KOZYR Today I shed some light on how Data Warehousing lies at the core of Retail Banking operations. We will see the actual case of vital marketing process malfunction and dive deep under the surface level to comprehend data alchemy technical issues. You will learn how to approach such issues, …

Read more

Optimizing Join and Aggregation with Teradata UNION ALL Views Widely read

Illustration of a glossy orange database cylinder with data fragments across its surface

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 performance.

How to Reduce Skew in Teradata Joins Using the RANDOM() Function Popular

Illustration of a stopwatch dial on an orange paint-splash background

Natural skew may hinder join performance, but the PRPD capability in Teradata 14 can alleviate this problem. However, PRPD may not detect all potential applications if skewed values are not evident in the statistics. If your Teradata version is below 14, PRPD is unavailable. To address this, you can use a technique based on the …

Read more

Teradata Sliding Window Merge Join: A Detailed Explanation Popular

Illustration of a stopwatch dial on an orange paint-splash background

Introduction to the Teradata Sliding Window Merge Join DWH Pro thoroughly analyzes the Teradata sliding window merge join, which has limited available information. Our extensive research provides valuable insights into this process. 🎓 Prefer video? Lecture 10 of my Udemy course Teradata Performance Tuning in Practice, “Sliding-window merge join on partitioned tables”, covers this topic. …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam