DWHPro Insights

aggregation

Teradata Tactical Workload Popular

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

Introduction This blog post discusses tactical workloads on a Teradata system. Despite Teradata’s implementation of features that support tactical workloads, this workload category remains challenging to manage. Selecting an optimal physical design is essential to meet user expectations for query speed. Designing the Teradata tactical workload on a test environment can be frustrating, especially when …

Read more

Understanding Teradata Load Isolation Most read

Illustration of a network graph with circular nodes joined by lines

Isolation Levels and their Impact on Performance & Concurrency Load isolation provides a defined committed view under its supported rules; it is not a blanket serializability or performance guarantee. Feature support and restrictions must be verified for the target deployment. Teradata provides varying degrees of isolation: In the next chapter, we will describe how these …

Read more

Teradata Access Paths: 8 Essential Ones to Know

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

Hash indexes remain supported: creation executed in the isolated fixture. Single-table join indexes offer overlapping and broader capabilities, but have not made hash indexes nonexistent. 🎓 Prefer video? Lecture 6 of my Udemy course Teradata Performance Tuning in Practice, “The access paths the optimizer can choose”, covers this topic. See the course on Udemy → …

Read more

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.

Protected by Security by CleanTalk and CleanTalk Anti-Spam