DWHPro Insights

full table scan

The Pitfalls of Teradata SELECT * Queries Popular

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

Introduction In a row-oriented database engine like Teradata, data is organized and stored in units called data blocks. Each data block features a fixed header and accommodates multiple rows. Every row consists of a record header followed by its corresponding columns. 🎓 Prefer video? Lecture 16 of my Udemy course Teradata Performance Tuning in Practice, …

Read more

Teradata Join Strategies: Merge, Hash, Nested and Product Joins Most read

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

Introduction Teradata offers several methods for conducting joins, but all necessitate one prerequisite. 🎓 Prefer video? Lectures 8 and 10 of my Udemy course Teradata Performance Tuning in Practice cover this topic: “Merge, hash, nested and product joins” and “Sliding-window merge join on partitioned tables”. See the course on Udemy → The paired table rows …

Read more

Optimizing Teradata Performance through Statistics and Primary Index Selection Widely read

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

1. Statistics In Teradata, understanding and managing statistics is essential for optimizing database performance. Statistics provide the optimizer with precise data about stored information, allowing for well-informed decisions when handling queries. This article will explore the significance of statistics in Teradata, their effect on query performance, and recommended methods for upkeep. The Role of Statistics …

Read more

How Join Indexes Can Optimize Performance in a Normalized Data Model

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

A normalized data model can increase the complexity of creating performant queries due to the higher number of tables that must be linked compared to a denormalized data model. It is essential to select a primary index precisely to optimize queries and joins, enabling them to have a direct access path. However, relationship tables often …

Read more

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

Teradata vs SQL Server: Key Architectural Differences and Performance Implications Widely read

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

This article will highlight the contrasting architectural features of Teradata and SQL Server, along with their shared aspects and performance impacts. The piece titled “Teradata versus SQL Server” will be periodically updated. For comparisons against other platforms: how Teradata and Amazon Redshift differ and what makes Teradata an RDBMS rather than an appliance. The same …

Read more

Maximizing Performance with Teradata Dynamic AMP Sampling: An Introduction Popular

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

Introduction to Teradata Dynamic AMP Sampling Dynamic AMP sampling supplies selected demographic estimates when optimizing. Do not include USI distinctness as though it needs sampling: uniqueness supplies that information. These samples do not replace full column histograms. A random AMP is selected for each table based on the row hash of its internal TABLE_ID, using …

Read more

Optimizing Teradata Queries: From No Index to Hashed NUSI Popular

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

The initial situation without any index In this blog, I will demonstrate how to optimize a query using Teradata’s tools. We will begin with the following test scenario: The data is evenly distributed. To demonstrate the query’s selectivity for the tested indexes we will define later, I assigned a significant portion of rows the same …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam