Group By Archives -

Teradata Join Indexes vs. Snowflake Materialized Views — A Technical and Pragmatic Comparison

03/09/202611/25/2025 by Roland Wenzlofsky

Database features should be compared based on their documented behavior, their operational impact, and the architectural principles behind them. This applies especially to physical optimization structures such as Teradata Join Indexes (JIs) and Snowflake Materialized Views (MVs)—two features often mentioned together during migration planning, yet substantially different in scope and design. The intention of this …

From QueryBand to Query Tag

04/11/202610/28/2025 by Roland Wenzlofsky

How to Track Query and User Activity After Migrating from Teradata to Snowflake By Roland Wenzlofsky · DWHPro 🎯 Why This Matters In Teradata, QUERY_BAND has long been a hidden gem — the ability to tag every query or session with metadata like App, Job, or UserGroup. That little string became the key to workload …

Teradata vs. Snowflake: Why GROUP BY Performance Differs at Scale

03/09/202609/27/2025 by Roland Wenzlofsky

When migrating analytical workloads from Teradata to Snowflake, one subtle but important performance factor often gets overlooked: how the two systems handle GROUP BY operations on huge tables. The SQL looks the same, but the execution engines behave differently. If you’ve relied on Teradata for years, you may be surprised by Snowflake’s behavior. GROUP BY …

The Teradata AMP Worker Task

04/11/202606/08/2023 by Roland Wenzlofsky

Introduction to the Teradata AMP Worker Task The Teradata AMP Worker Task or AWT is the heart of the AMP, responsible for executing tasks and ensuring the smooth functioning of the system. AWTs are threads that process incoming tasks in the AMP. Each AMP has a finite pool of AWTs, which is shared among all …

Improving SQL Performance with Simple Query Rewrites: Dealing with Duplicates and Business Calendars

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

The Teradata flavor of SQL is still, in principle, a declarative language. Hence, there can be multiple ways to describe an SQL query and achieve the same result. While the answer is the same, Teradata may use a completely different execution plan based on how the query is expressed. One approach is investing in heavy …

Teradata GROUP BY vs. DISTINCT- Aggregation Methods

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

Learn about the differences between GROUP BY and DISTINCT for aggregations in Teradata. The optimizer now selects the appropriate algorithm depending on data demographics. Understand when to use each method to optimize query performance.

SQL Tuning Goals: Improving Performance and Reducing Resource Usage

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

Learn about the goals of SQL tuning and how to optimize database performance by reducing resource usage. Skew, IOs, and CPU seconds are key metrics. Discover how to ensure completeness and correctness of Teradata statistics, detect missing and stale statistics, and improve query plans.

Understanding Teradata Flow Control Mode for Efficient Workflow Management

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

Introduction Teradata efficiently manages complex workflows by distributing and expanding processes across numerous AMPs. However, when an AMP’s maximum capacity is reached, it can initiate flow control mode. This blog post delves into Teradata’s Flow Control Mode, its impact on performance, and effective monitoring and management strategies. How It Works Teradata’s decentralized architecture distributes workload …

Optimizing Teradata Performance through Statistics and Primary Index Selection

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

1. Statistics In Teradata, understanding and managing statistics is essential for optimizing database performance. Statistics provide the optimizer with precise data about stored information, allowing for well-informed decisions when handling queries. This article will explore the significance of statistics in Teradata, their effect on query performance, and recommended methods for upkeep. The Role of Statistics …

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 …