Teradata ORDER BY and Performance If we chose a simple sort method, all rows would have to be available in ...

How Teradata ORDER BY affects your query performance

Like most relational database systems, Teradata creates a copy of each row modified for most DML statements. Teradata uses the ...

The Teradata Transient Journal

Introduction to Teradata Sparse Maps The Teradata hashing architecture and how AMPs are used to split tables for maximum parallelism ...

Teradata Sparse Maps

What are Deadlocks in Teradata? Deadlocks occur when each of two transactions holds the lock on a database object the ...

Teradata Deadlock Prevention

This article will show the key architectural differences between Teradata and SQL Server and the similarities and performance implications. The ...

Teradata versus SQL Server – Tuning Considerations

What is a Teradata AMP? AMP is the abbreviation for Access Module Processor. Each Teradata AMP is a Linux process ...

The Teradata AMP and its Worker Tasks (AWT)

The bottleneck of database systems has always been accessing the data. As soon as the data is in the main ...

Teradata WAL – The Write-Ahead Logic

Teradata moved towards the cloud to avoid losing the connection to modern cloud databases. I will show you the AWS ...

Teradata AWS – In The Cloud

What Are Zero-Copy Clones? We all know the following situations: For certain operations, we need to make a backup of ...

What Snowflake Does Better Than Teradata: Zero-Copy Clones

Introduction to Teradata in the Cloud Cloud databases put traditional MPP systems in data warehousing under increasing pressure. This blog ...

Teradata in the Cloud?