Sign in Subscribe

Performance Tuning

A collection of 267 issues

Optimal Performance by Avoiding CHARACTER Columns in the Primary Index

The Teradata Primary Index and Hash Collisions Using either INTEGER or CHARACTER data types for the Teradata Primary Index does not usually impact performance. The hashing algorithm in Teradata is highly efficient. In the rare case where primary index columns from different tables have different CHARACTER SET, there may be

Optimizing Workload with Teradata's Sample Statistics Feature

Learn how to gather statistical samples in Teradata systems to reduce workload and generate comparable execution plans through sample statistics.

Teradata Identity Columns: Features, Benefits, and Syntax

Learn about the features and benefits of Teradata Identity Columns, and why they are used for transactional and bulk inserts. Discover the data types, syntax, and more.

Why Selecting Only Needed Columns Boosts Performance: Teradata Query Example

Learn why selecting only necessary columns can improve query performance. This article includes an example query and execution plan analysis.

Optimizing the Tactical Workload in Teradata: Skills and Tools Needed

Learn about tactical workload tuning in Teradata, which requires unique skills and tools. This article covers the skills needed to optimize tactical queries and highlights the difference between tactical and decision support workloads. Discover the Tactical Workload Toolkit and how to use join index

The Vulnerability of Outer Joins in Business Intelligence Tools: A Simple Test Scenario

Learn why business intelligence tools often use outer joins and why they can be vulnerable to skewing. Read on to understand the details and risks involved.

Teradata Dynamic Workload Management Features: What You Need to Know

Teradata Active System Management (TASM) offers dynamic workload management features that allow workload adaptation based on system conditions. Learn more here.

Optimizing Teradata Queries: A Case Study on Generating Rows Between Start and End Dates

Learn how to optimize SQL queries in Teradata with this case study. See how a recursive query was replaced with a more efficient approach.

Manage and Monitor your Teradata System with Teradata Viewpoint: Features and Capabilities Explained

Teradata Viewpoint is a web-based tool for monitoring and managing Teradata data warehousing systems. This article explores the tool's functionalities and how to utilize it for monitoring and managing your Teradata system. What is Teradata Viewpoint? Teradata Viewpoint is a web-based tool that provides a single access point

Teradata Comparison Operators and Performance: Why Choosing the Right Operator Matters

Learn how Teradata Comparison Operators and Performance are linked, and how choosing the right operator can impact query performance. Column statistics play a crucial role in the Teradata Optimizer, and this article explores how to use them effectively.