Sign in Subscribe

Teradata

A collection of 307 issues

How to Analyze Teradata Tables for Multivalue Compression: A Less Costly Method Using SHOW STATISTICS VALUES COLUMN ON

Learn how to analyze Teradata tables for Multivalue compression without costly operations by using the SHOW STATISTICS VALUES COLUMN statement. This method delivers excellent compression suggestions with less resource and time consumption than traditional approaches. However, it only works for colum

Mastering Teradata Performance Optimization: Introduction to Partial Redistribution and Duplication

Introduction to Teradata Partial Redistribution and Partial Duplication Managing data skew is a critical aspect of optimizing Teradata performance. While table-level skew can typically be prevented by selecting an appropriate Primary Index, spool skew occurs during query execution - a common and often significant problem. Spool skew is a common

Teradata Locking Logger: How to Enable and Analyze Lock Activity

Turning on the Teradata Locking Logger by Vasudeva Rao To activate the locking logger, access the DBS console window or cnsterm subsystem and ensure it is enabled. Note that the change will only take effect once the database has been restarted. Below is the dbscontrol help output for the flag

Teradata 16 Introduces New Features for UNION ALL Queries

Teradata Built-In Functions: TO_NUMBER, TRUNC, CEILING, FLOOR, LEAST, GREATEST, ROUND

TO_NUMBER I have often needed a function to verify whether a character column contains a numeric value. Typically, I have resorted to using a workaround, such as: CASE WHEN UPPER('12.77') = LOWER('12.77') THEN 'IS_NUMERIC' ELSE 'IS_NOT_NUMERIC&

Introduction to Teradata Big Data Blocks: Advantages and Disadvantages

Teradata Big Data Blocks - Introduction Teradata 13.10 introduced larger file systems components, such as cylinders and data blocks. The cylinder size was increased from 1.9 MB to 11.3 MB, while the data block size limit was raised from 127.5 KB to 1 MB in Teradata

The Impact of Character Sets on Teradata SQL Performance: A Case Study

As a Teradata SQL specialist, I find skew to be a common challenge. In fact, approximately 90% of SQL performance difficulties stem from skew, based on my experience. However, this article focuses on the potential for minor modifications to yield significant improvements. This article highlights the potential consequences of selecting

Teradata Utility Workload Management: Overview and Protocols

Learn about Teradata Utility Workload and its specialized and optimized user requests that are not SQL protocol-based. Explore its protocols and management techniques.

Understanding Teradata Workload: Definition, Advantages, and Characteristics

Learn about Teradata Workload and its benefits in this article. Workloads group requests with common characteristics, making it easier to manage them.

Global Teradata System Characteristics Database: Help Us Build It!

Teradata administrators worldwide face similar challenges. I propose creating a worldwide database containing the characteristics of Teradata systems. This will allow for easy comparison and analysis of performance issues between different systems. My initial report displays the CPU idle time and the number of disk I/O waits for every