Sign in Subscribe

Performance Tuning

A collection of 267 issues

Understanding Teradata Secure Zones: A Clear Explanation and Possible Use Cases

Teradata Secure Zones I've had a few conversations recently with different customers about the "Secure Zones" optional feature added in Teradata 15.10. There is a fair amount of misunderstanding about what this feature offers and does. This article aims to provide some clear information for

Teradata Sliding Window Merge Join: A Detailed Explanation

Teradata Pro is now DWH Pro!

Teradata Show Table Proxy: Recreate Full DDL from DBC Tables and Views

A Teradata Show Table Proxy for Full DDL Recreation from DBC Throughout my recent development activities, an old desire became relevant again. It goes as follows: Can one write a query that recreates the entire DDL of a table out of dbc views or tables alone? Want more practical data

Teradata Physical Storage: Exploring Data Blocks and Storage Demographics

DISTINCT vs. GROUP BY: Understanding Performance Differences Based on Data Demographics in Teradata

Over the years, numerous debates have emerged concerning the superior performance of specific statements: SELECT <COLUMN> GROUP BY 1 or SELECT DISTINCT <COLUMN> Many personal experiences are often shared but tend to misattribute causality. People usually construct a single test scenario and extrapolate sweeping conclusions from

Teradata Historisation - Daily snapshot to change history

For various reasons, we may need to switch our Teradata historisation from snapshot tables to a start date/end date logic table, which I usually call a change history, as only changes trigger a historisation. A principal motivation for such a move away from a daily snapshot table could be