Transactions Archives - Page 2 Of 5 -

Teradata TD_WhichMax and TD_WhichMin Functions: A SQL Solution for Finding Min/Max Value of a Column with Low Resource Consumption

04/11/202605/05/2023 by Roland Wenzlofsky

What is the Teradata TD_WhichMax Function? Teradata releases new SQL features with each update, providing enhanced functionality and improved performance with reduced resource usage. We will examine the Teradata TD_WhichMax and TD_WhichMin functions and explore their potential benefits. These functions retrieve the minimum or maximum value of a column and are commonly utilized in SQL …

A Beginner’s Guide to Teradata Multiload and Fastload

04/11/202605/05/2023 by Roland Wenzlofsky

Introduction to Teradata Multiload and Fastload

Understanding Teradata Statistics Histograms: How the Optimizer Estimates Cardinality for WHERE Conditions

04/11/202605/05/2023 by Roland Wenzlofsky

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 my observations may be attributed to a bug, I wanted …

Teradata Join Strategies: How to Optimize Join Operations

04/11/202605/03/2023 by Roland Wenzlofsky

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 for each join method varies. The choice of Teradata join strategy utilized by the Optimizer is determined by …

Mastering Teradata Performance Tuning

04/11/202605/03/2023 by Roland Wenzlofsky

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 rephrasing a query using this example. Assuming this scenario: One table has a minimal number of rows, while the other is partitioned and …

Understanding Teradata Locking: Types and Granularity

04/11/202605/03/2023 by Roland Wenzlofsky

Learn about locking in Teradata to ensure data integrity and consistency. Teradata automatically selects the best lock for each situation to prevent data inconsistencies.

Introduction to TPT Teradata: Streamline Your Data Loading

04/11/202605/03/2023 by Roland Wenzlofsky

Learn about Teradata’s Parallel Transporter Utility (TPT), the all-in-one tool that combines Fastload, Multiload, TPUMP, BTEQ, and Fastexport functionalities. Discover the benefits of TPT’s consistent syntax and parallelism, as well as a comprehensive overview of its operators.

Understanding Deadlocks in Teradata: Prevention and Handling Strategies

04/11/202605/03/2023 by Roland Wenzlofsky

What are Deadlocks in Teradata? Deadlocks arise when two transactions hold locks on database objects required by the other transaction. Here is an example of a deadlock: Transaction 1 locks some rows in Table 1, and transaction 2 locks some rows in Table 2. The next step of transaction 1 is to lock rows in table 2, and …

How to Simplify Database-to-Database Table Copying with Teradata Parallel Transporter (TPT) and tdload

04/11/202605/03/2023 by Roland Wenzlofsky

The Teradata Parallel Transporter (TPT) is a Teradata Tools and Utilities (TTU) product. Teradata TPT offers under one roof an SQL-like scripting language that simplifies the syntax of old Teradata Utilities for handling external data (e.g., FastLoad, MultiLoad, TPump, BTEQ, and FastExport). Copying Tables between Teradata Systems A classic approach to perform a database-to-database table …

Teradata Table Skew: Understanding Natural and Artificial Skew with DBC.TableSizeV

04/11/202605/02/2023 by Roland Wenzlofsky

Teradata table skew is a common issue encountered while working with the Teradata database. If you’re reading this page, you may have experienced this problem. Common knowledge When searching for Teradata table skew or skew factor online, most or all documentation will refer directly to DBC.TableSizeV for computation. To analyze table skew, the commonly used …