The Teradata Primary Index and Hash Collisions Typically it makes no difference whether we use INTEGER data types or CHARACTER ...

Character data types as performance killers for the Teradata Primary Index

Data Modeling Considerations and Teradata MULTISET TablesIn relational data modeling theory, each entity needs a primary key. Each primary key ...

Using Teradata MULTISET tables correctly

Introduction to Teradata Compression A small message at the beginning: Teradata Block Level Compression is now always enabled and cannot ...

Teradata MVC, BLC, Or Both?

Block Level Compression (BLC) is always enabled in the latest generation of Teradata systems. Usually, the compression factor is shallow ...

Teradata Row Level Partitioning – Save Permanent Space

I will briefly overview how rows are distributed in Teradata to understand the problem of hash collisions in Teradata. If ...

How You Can Reduce Teradata Hash Collisions

Why IOs are so crucial in Teradata The minimization of IOs in Teradata is one of the essential goals in ...

Teradata IO Optimization

The golden rules for Amazon Redshift optimization Customize Workload Management Workload management in Redshift means optimizing the queues. This includes ...

Amazon Redshift Tuning – 7 Golden Rules You Must Never Forget!

Introduction to Teradata Volatile Tables and Snowflake Temporary Tables Both Teradata and Snowflake offer temporary tables. In this blog post, ...

Teradata Volatile Tables vs Snowflake Temporary Tables

Often we have already reduced the size of our tables immensely using Multivalue Compression, and yet we need more space. ...

Reduce An Already Compressed Teradata Table To 10% Of Its Size!

How Do I Select The Appropriate Data Type In Teradata? Datatype conversions are very costly and can require a lot ...

Tuning With Teradata Data Types – Choose Them Wisely!