Teradata
A collection of 307 issues
Date ranges and business calendars beyond recursion and Teradata SYS_CALENDAR
In a previous article, Roland explained how to use recursion to build a data range without touching a physical table. This time, we explore an alternative approach that avoids recursion at the expense of single-AMP, single-row access. We can use this approach to build both a wide date range as
Maximizing Performance and Space Savings: Teradata Compression Techniques
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 the continued advantages of multi-value compression (Teradata MVC).
With Teradata's introduction of block-level compression, the utilization
Teradata strtok_split_to_table, CSVLD, Unpack: Column Splitting in Teradata
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 sufficient random data to assess every option's efficiency and
Comparing Index Types of SQL Server and Teradata: Clustered vs Row Partitioning, Non-clustered vs NUSI, USI, Join Index, and More
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 different architectures.
Clustered Index vs Teradata Row Partitioning
The SQL Server's clustered index arranges table rows in a specific physical
A Beginner's Guide to Teradata Multiload and Fastload
Introduction to Teradata Multiload and Fastload
What is the Teradata Multiload?Teradata Multiload is a utility that supports loading data (INSERT) and other DML statements (UPDATE, DELETE, UPSERT). All DML statements are executed optimally, and changed data blocks are written only once. Furthermore, Teradata can process several tables at once.
How the Number of Rows per Data Block Affects Teradata NUSI Selectivity: A Case Study
Teradata NUSI Selectivity and Data-Block Density
The goal of this article is to show how the number of rows per base-table data block impacts the selectivity threshold for Non-Unique Secondary Indexes (NUSI) in Teradata.
Understanding this correlation is critical when analyzing query plans and tuning indexing strategies.
The number of
Teradata Index Selection: Factors to Consider
Understanding Teradata Statistics Histograms: How the Optimizer Estimates Cardinality for WHERE Conditions
Teradata Statistics Histograms - A Short Introduction
Many are familiar with the Optimizer's statistical confidence levels. I was recently surprised to discover that a "high confidence" rating does not guarantee a fully accurate estimation (provided the statistics collected are not stale). While I remain hopeful that
Hadoop and Teradata Data Warehousing: A Comparison and Integration Perspective
Hadoop is a buzzword in the world of big data, but its actual value can be concealed by the hype. This article compares Teradata and Hadoop Data Warehousing, highlighting the advantages of leveraging Hadoop's scalability and preprocessing capabilities to improve Teradata's performance. However, the