Sign in Subscribe

Performance Tuning

A collection of 267 issues

The Teradata NUSI (Nonunique Secondary Index)

The Teradata NUSI is an alternative access path to table rows, similar to other relational database indexes. Indexes are used to minimize resource consumption, especially IOs. Unlike Oracle, Teradata employs a hashing method for indexing, which is a common method for shared-nothing database systems. Amazon Redshift and Postgres-based database systems

Teradata PPI: Understanding Partitioned Primary Index for Improved Performance

Learn about the benefits of partitioned primary index (PPI) in Teradata, a method for reducing I/Os and improving performance in database systems.

Extracting Numeric Tokens from Strings with CHAR2HEXINT Function in Teradata SQL

Learn how the CHAR2HEXINT function helped solve a real-world problem of extracting number parts from a string in Teradata SQL. Read on for the solution.

Introduction to Temporal Data Management in Teradata

Learn about Teradata's temporal data management functionality based on TSQL2 specification in this article. Discover how it simplifies historization.

Improvements in Tailoring Statistics Collection with Teradata 14.00: Using Sample, MaxValueLength, and MaxIntervals Options

Learn about the latest improvements in Teradata 14.00 that allow you to customize the collection of statistics to better suit your needs. These improvements include the option to set different sample sizes, consider more bytes for histogram creation, and choose the number of intervals for building s

What is Block Level Compression (BLC) and How Does it Work for Teradata?

Block Level Compression (BLC) is a feature that allows compression of entire data blocks, leading to disk space reduction. Read on to know more.

Variable Declarations in Teradata Stored Procedures

Learn how variable declarations work in a Teradata Stored Procedure. Declarations are always local to the surrounding compound statement. See examples.

Teradata Hash Index: Minimizing Disk IOs and Optimizing Row Access

Learn about the Teradata Hash Index, designed to minimize disk IOs and improve access to rows. Discover how it differs from Single Table Join Indexes.

Teradata SQL Tuning: Minimizing Costs and Maximizing Parallelism

Learn how to optimize SQL tuning on Teradata by minimizing I/Os and maximizing parallelism, which can be achieved by evenly distributing rows across all AMPs.

Decomposable Columns: Definition, Impact on Performance, and Workarounds

Learn about decomposable columns, which can be split and lead to better performance for data access. Find out how to optimize their use in this guide.