Introduction to Teradata Compression Note: Teradata Block Level Compression is now permanently enabled and cannot be turned off. Nonetheless, this article remains useful for current Teradata systems utilizing block-level compression. It demonstrates...
Splitting column content can be a challenging task. Teradata provides multiple methods to achieve this, each with unique pros and cons. In this article, we will examine these techniques in detail. To begin, we will generate a table containing suffici...
This article compares the index types in SQL Server and Teradata. It can benefit those transitioning between the two platforms to understand their distinctions and overlaps, despite their disparate architectures. Clustered Index vs Teradata Row Parti...
Introduction to Teradata Multiload and Fastload Introduction to Teradata Multiload and Fastload
The primary goal is to show how the number of rows per base table data block impacts selectivity. The example highlights the correlation between Teradata NUSI selectivity, the average size of data blocks, the size of rows, and the number of rows per...
The Teradata Tutorial to support the selection of indexes The Teradata Tutorial to support the selection of indexes
Introduction Teradata offers several methods for conducting joins, but all necessitate one prerequisite. The paired table rows must reside on identical AMPs. The chosen method for joining and relocating data is called a join strategy. The preparation...
The Art of Teradata Performance Tuning As a Teradata Performance Tuner, technical expertise and experience are essential, occasionally accompanied by fortuitous circumstances. I’ll demonstrate the remarkable outcomes that can be attained by rephrasin...
Someone recently inquired about how the Teradata Optimizer utilizes multi-column statistics. These are the key facts: The Optimizer employs multi-column statistics when the query’s WHERE clause refers to all columns. This example pertains to Teradata...
The Teradata Express Edition is a great chance to experiment with a fully functional Teradata System. It can be downloaded from https://downloads.teradata.com/download/database. Regrettably, solely VMWare is the supported virtualization software. As...