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

Teradata Skewing: Causes, Detection, and Solutions Widely read

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

Learn how to detect and prevent Teradata skewing, one of the main causes of slow query performance. Discover the different types of skew and how to analyze tables, joins, and column values to detect and resolve issues. With practical tips and example queries, this article is a must-read for performance tuners and database administrators.

Protected by Security by CleanTalk and CleanTalk Anti-Spam