statistics Archives - Page 3 of 6

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

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

Icon of a chrome hammer inside an orange circle over a brick pattern

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 …

Streamlining Table Cloning in Teradata and Leveraging Zero-Copy Cloning in Snowflake

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

Illustration of three stacked database units of differing heights inside a circle

Table cloning is required for purposes such as data backup, testing, and replication. Teradata, a leading data warehousing platform, provides an efficient method for cloning tables. However, Snowflake, a cloud-based data warehousing platform, offers an even more effective approach with its zero-copy cloning feature. This article will compare table cloning in Teradata with Snowflake’s zero-copy …

Teradata Join Strategy: The Benefits and Costs of Merge and Product Join Methods

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

Illustration of a stopwatch dial on an orange paint-splash background

Teradata employs various join methods and techniques to merge the rows of two tables onto a single AMP, which is essential for joining. The combination of join technique and data geography is called the join strategy, and its goal is to reduce resource consumption (CPU seconds, I/Os). Some join methods, like the Teradata Merge Join, …

Teradata Tactical Workload

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

Introduction This blog post discusses tactical workloads on a Teradata system. Despite Teradata’s implementation of features that support tactical workloads, this workload category remains challenging to manage. Selecting an optimal physical design is essential to meet user expectations for query speed. Designing the Teradata tactical workload on a test environment can be frustrating, especially when …

Tracking Teradata Statistics Usage with StatUseCountV Popular

08/22/202605/02/2023 by Roland Wenzlofsky

Illustration of a person in a suit standing beside a database cylinder

How to find out if the Teradata Statistics we created for a specific workload are used? Teradata statistics greatly affect SQL query efficiency. We need a reliable method to get this information. Various objects, such as tables and join indexes, can have statistics collected on them. As performance tuners, it is important to confirm their …

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

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

1. Complete and up-to-date Statistics At the start of Teradata SQL Tuning, statistics are a vital concern. The Teradata Optimizer employs statistics to formulate the optimal execution plan for our query. The adequacy of statistics or dynamic AMP sampling varies according to the data demographics. To initiate optimization, updated statistics must be provided to the …

Maximizing Performance with Teradata Dynamic AMP Sampling: An Introduction

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

Introduction to Teradata Dynamic AMP Sampling Teradata calculates dynamic AMP samples for indexed columns (PI, USI, NUSI) at runtime without requiring statistics. These samples provide key information, including table cardinality and distinct values. They are stored in the FSG cache of each AMP’s table header. This process is referred to as dynamic AMP sampling. A …

Optimizing Teradata Statements Containing Multiple JOINS

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

1. Outline This showcase demonstrates optimizing statements with multiple JOINs using Teradata Optimizer’s tuning approach. The approach efficiently determines the best JOIN strategy and implements data redistribution instead of duplication when necessary. Identify and break down underperforming segments to optimize complex logic with multiple joins. Employ an execution plan and monitor query performance and resource …

Optimizing Queries with LIKE Operator in Teradata

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

Illustration of a glossy orange database cylinder with data fragments across its surface

Learn how to optimize LIKE operator queries in Teradata to avoid full table scans and improve performance. Read on for expert tips and tricks.

Teradata Statistics Design for High Performance: An Introduction

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

Learn how Teradata 14.10 simplifies statistics collection for better performance. Discover new features that identify unused and missing statistics.