AMP Archives - Page 7 of 8

Teradata Query Parallelism: A closer look at how Teradata’s shared-nothing architecture and parallel processing capabilities deliver exceptional performance. Popular

04/11/202604/28/2023 by Roland Wenzlofsky

Illustration of three stacked database units of differing heights inside a circle

Teradata Query Parallelism A query on a Teradata system runs in parallel at every step, whether for joining, sorting, or aggregating data. Teradata’s uniqueness lies in its ability to apply parallelism at every step of the query process. This advantage resulted from its architectural design, which integrated high levels of parallelism from the start, even …

Achieve Incredible Teradata Join Performance

04/11/202604/28/2023 by Roland Wenzlofsky

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, …

Teradata Priority Scheduler and Resource Allocation Rules Popular

04/11/202604/28/2023 by Roland Wenzlofsky

Illustration of a person in a suit standing beside a database cylinder

Learn about Teradata’s priority scheduler and how resources are allocated across workloads and requests in this detailed guide on workload management.

Optimizing Teradata Requests with Group-AMP Operations for Improved Performance

03/08/202604/28/2023 by Roland Wenzlofsky

All-AMP and single-AMP operations are well-understood. All-AMP retrieval typically involves full table scans, including NUSI sub-table scans. On the other hand, single-AMP retrieval typically involves indexed access, such as UPI and NUPI. Group-AMP operations optimize requests by minimizing the number of active AMPs. These operations fall between single-AMP and all-AMP operations. The Optimizer employs group-AMP …

How to Improve Cardinality Estimations in Teradata: The Optimizer’s Toolkit

04/11/202604/28/2023 by Roland Wenzlofsky

Learn about Teradata Heuristics and Optimizer’s approach to estimating cardinality for non-indexed columns in this article. Discover how skew improves estimations and why heuristics should be avoided.

Understanding Teradata Nodes in Parallel Systems: Architecture and Scalability

04/11/202604/23/2023 by Roland Wenzlofsky

Learn about Teradata Nodes – Linux systems packed into cabinets with multicore CPUs, memory, and parallel database extension software (PDE).

Optimal Performance by Avoiding CHARACTER Columns in the Primary Index

04/11/202604/22/2023 by Roland Wenzlofsky

The Teradata Primary Index and Hash Collisions Using either INTEGER or CHARACTER data types for the Teradata Primary Index does not usually impact performance. The hashing algorithm in Teradata is highly efficient. In the rare case where primary index columns from different tables have different CHARACTER SET, there may be minimal performance losses, but this …

Teradata Architecture: The Pioneer of Data Warehousing Popular

04/11/202604/21/2023 by Roland Wenzlofsky

Illustration of three stacked database storage units of differing heights against abstract chart shapes

Learn about the basics of Teradata architecture and why it’s still a top RDBMS for Data Warehousing. Discover how the system is built for parallelism and how hashing algorithms help distribute data evenly among AMPs. Explore the essential roles of Parsing Engines, AMPs, and Nodes in executing instructions and managing resources.