Performance Tuning
A collection of 267 issues
Accelerating ETL with Snowflake: A Comparison of Load Times with Teradata
Enhancing Your Teradata Vantage Design with Teradata Historisation: A Comprehensive Method
Teradata ALTER Table vs. INSERT INTO: Which Method is Efficient?
Teradata ALTER Table versus INSERT INTO
Altering the structure of a substantial Teradata table can consume significant resources. Essentially, there are two approaches: altering the DDL through Teradata ALTER TABLE or generating an empty table with the desired DDL statement and transferring data via the Teradata INSERT INTO statement. Each
Improving Query Performance with Teradata Statistics Extrapolation and Object Use Counts (OUC)
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
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,