Indexing
A collection of 141 issues
How Survival Instinct Is Reshaping the Data Warehouse
Every data platform eventually faces the same question: how do you serve both the analyst running a full-table scan across billions of rows…
Understanding Skew in Teradata and Snowflake
Performance degradation caused by uneven workload distribution is one of the oldest and most persistent challenges in parallel data warehouse systems. Both Teradata and Snowflake can experience this imbalance, commonly known as skew.
Although the term is shared, the mechanics differ fundamentally: Teradata can suffer from both persistent and runtime
Why the Same UPDATE Means Something Entirely Different in Teradata and Snowflake
At first glance, an UPDATE looks universal.
In reality, it’s one of the most misleading similarities between Teradata and Snowflake.
The SQL is the same, but the storage, logging, recovery, and performance mechanics are completely different.
If you’re migrating from Teradata to Snowflake (or running both), understanding these
Teradata vs. Snowflake: Why GROUP BY Performance Differs at Scale
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
Skewed Joins, Straight Answers: A Neutral Guide for Snowflake/Teradata Teams
Snowflake’s physical join execution is predominantly hash-based. In practice you’ll observe hash-join variants with two distributions:
* Broadcast hash joins — replicate a small build side to all workers (warehouse nodes) and join locally.
* Partitioned (shuffle) hash joins — repartition both inputs by the join key so matching keys land on
Fast multi-file export of Teradata query results using only Teradata SQL Assistant
Optimizing Teradata SQL Queries by Avoiding Full Table Scans and Utilizing Secondary Indexes
Learn how to optimize your Teradata SQL performance by leveraging secondary indexes! Avoid full table scans by bypassing the COALESCE function in the WHERE clause.
Outsmarting Teradata Limitations: A Workaround for Teradata Identity Columns in Volatile Tables
Learn how to overcome the hurdle of using Teradata Identity columns with Volatile Tables. Discover a workaround using the 'CREATE TABLE AS' statement.
When Teradata Space Shortage Impacts System Performance
Running out of free Cylinders in Teradata
Encountering a situation where free cylinders are exhausted is a significant concern when managing a system, and no more Teradata Space is available. It's an issue that can adversely impact the operations and efficiency of the database, leading to potential slowdowns