The latest generation of Teradata systems always has Block Level Compression (BLC) enabled. When using MultiValue compression, the compression factor ...

Save Space with Teradata: Utilizing Block Level Compression and Row Partitioning

Introduction This blog post discusses tactical workloads on a Teradata system. Despite Teradata’s implementation of features that support tactical workloads, ...

Teradata Tactical Workload

This article assumes prior basic knowledge of Python and demonstrates the easy process of loading data using Python and the ...

Loading Data into Teradata using Python and Fastload

How to find out if the Teradata Statistics we created for a specific workload are used? Teradata statistics greatly affect ...

Tracking Teradata Statistics Usage with StatUseCountV

Problem-solving without a Teradata Recursive Query To depict a corporate hierarchy in our instance, we can employ a non-recursive approach, ...

The Teradata Recursive Query for Performance Tuning

Teradata is commonly used for tactical workloads and OLTP applications in my projects. However, it is crucial to avoid designing ...

Designing Teradata Row Partitioning for Optimal Performance in Tactical Workloads

This article illustrates loading a flat file into an empty Teradata table using TPT. The example was successfully tested on ...

How to Load a Flat File into an Empty Table with Teradata TPT: A Simple Example

1. Complete and up-to-date Statistics At the start of Teradata SQL Tuning, statistics are a vital concern. The Teradata Optimizer ...

The Importance of Up-to-Date Statistics for Teradata SQL Tuning

This article will highlight the contrasting architectural features of Teradata and SQL Server, along with their shared aspects and performance ...

Teradata vs SQL Server: Key Architectural Differences and Performance Implications