DWHPro Insights

primary index

“Explore Teradata’s Shared Nothing Architecture with Our Video Course”

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

This historical video introduces Teradata’s classic shared-nothing architecture and component interactions. Hashing does not guarantee even data or workload distribution: primary-index values, maps and intermediate-result skew matter. Platform-specific details in the recording should be checked against current documentation. http://youtu.be/uwRdLr8sRdY

Optimal Performance by Avoiding CHARACTER Columns in the Primary Index Widely read

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

The Teradata Primary Index and Hash Collisions Primary-index data types, character sets and collations can materially affect hashing, comparison and join conversions. Choose types for correct business semantics and compatible joins; benchmark relevant access paths before changing them. This article addresses a performance issue with CHARACTER columns in the primary index. Although not as apparent …

Read more

Learn Essential Teradata SQL Statements and Functions for Data Warehousing and Analytics Widely read

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

Learn the most essential Teradata SQL statements and functions in this article. From CREATE TABLE to Teradata-specific hashing functions, enhance your data manipulation and analysis capabilities on the platform. Whether you’re a beginner or an experienced user, this guide will help you master Teradata SQL skills.

Teradata SQL Tuning: How to Optimize Queries for Stable Runtimes Popular

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

Learn how to optimize Teradata SQL Tuning with comprehensive analysis of available tools in this article. Discover the optimal approach for query optimization for both tactical and strategic workloads, as well as methods for eliminating full table scans, reducing skew, and examining the execution plan. Plus, find out how to address common issues like concurrency and misestimation.

Maximizing Teradata Table Performance with BLC, Row-Level Partitioning, and Data Block Size Tuning Popular

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

BLC, Row Level Partitioning, and Datablock Size Tuning The sizes and diagrams below are historical observations: the original data, allocation and effective BLC policy are unavailable, so they have not been reproduced. In this article, we will learn how block-level compression, row-level partitioning, and selection of the appropriate data block size can be used to …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam