Sign in Subscribe

Teradata

A collection of 307 issues

Understanding Teradata Hash Collisions - A Case Study

To comprehend the issue of Teradata hash collisions, I will briefly explain how rows are allocated. If you are unfamiliar with Teradata Architecture or require a refresher, I suggest reading the following article beforehand: https://letters.dwhpro.com/content/files/2026/05/teradata-physical-storage.html As you know, a hashing algorithm

Teradata Rollbacks: Understanding the Impact on Performance and How to Avoid Them

What is a Teradata Rollback?A rollback reverses an incomplete transaction. Transactions can be unfinished for various reasons, such as user termination or database restart. Rollback ensures database integrity and is an essential aspect of an RDBMS. Rollbacks are implemented in Teradata using the DBC.TransientJournal table. A Before Image

The Importance of Minimizing Teradata I/O: Understanding Logical vs. Physical IOs and Their Impact on Performance

Why is Teradata I/O so crucial? Minimizing Teradata I/O is a crucial aspect of performance tuning. IOs involve transferring data from storage to main memory, which is essential for Teradata to process data. Transferring data to the main memory is significantly slower than accessing data in the main

Customize Your Redshift Workload Management System for Optimal Performance

Teradata Columnar Solution: Advantages and Disadvantages

How Advanced Is The Teradata Columnar Solution? A Column Store is defined by three distinct properties: * Improved compression compared to Row Stores. This results from considerably better compression rates that we can achieve by packing columns into data blocks. Since the values of a column come from a domain, the

Improving Database Performance and Security with Teradata Write-Ahead Logging (WAL)

Accessing data has always been the bottleneck of database systems. Once the data resides in the main memory, it can be promptly processed. Although SSDs are now predominantly used instead of hard disks, copying data into the main memory remains the slowest operation. The Teradata Write-Ahead Logging (WAL) feature enhances

Understanding Teradata's Primary AMP Index for Improved Performance

Experienced Teradata users are familiar with the concept of a primary index. However, a new term has surfaced with the introduction of Teradata Release 15: Primary AMP Index. This blog post will demonstrate a Primary AMP Index's benefits and optimal usage for improving load and query performance. First,

Switching from Teradata to Snowflake: What to Know About DML Statements and Data Deletion

Zero-Copy Clones: A Space and Time-Saving Solution for Database Management with Snowflake