Sign in Subscribe

Performance Tuning

A collection of 267 issues

Teradata SQL Tuning: How Query Rewriting Can Reduce Runtime from 40 Minutes to Seconds

It's time to share a new Teradata SQL tuning case study that showcases the impressive impact of query rewriting on performance. We are studying the query below that originally took 40 minutes to run. As a SQL tuning specialist, I always prioritize adding missing statistics and refreshing stale

Teradata vs. Redshift: A Comparison of Join Strategies and Architecture

High-Performance Calculations with Teradata Ordered Analytical Functions

Teradata employs two distinct approaches in Ordered Analytic Functions for preparing the data layout necessary for processing. This article explains both approaches and their respective advantages and disadvantages. Teradata Ordered Analytical Functions Teradata Analytic Functions are versatile tools that allow for a wide range of applications. The ability to retrieve

Detecting Overlapping Time Periods with Teradata OVERLAPS Command: A Simple Syntax Guide

Learn how to use the Teradata OVERLAPS command to detect overlapping time periods with this example query. Caution: minimum overlap required.

Optimizing Teradata Statements Containing Multiple JOINS

1. Outline This showcase demonstrates optimizing statements with multiple JOINs using Teradata Optimizer's tuning approach. The approach efficiently determines the best JOIN strategy and implements data redistribution instead of duplication when necessary. Identify and break down underperforming segments to optimize complex logic with multiple joins. Employ an execution

Optimizing Queries with LIKE Operator in Teradata

Learn how to optimize LIKE operator queries in Teradata to avoid full table scans and improve performance. Read on for expert tips and tricks.

Teradata Columnar Compression Methods: Run-Length, Dictionary, and Delta Compression

Learn about the benefits of compression in Teradata Columnar, including a reduction in permanent space and disk IOs. Different compression methods are used, including run-length, dictionary, and delta compression. This article explains how each method works and the advantages of using them.

Designing Small Reference Tables for Teradata: Storing All Rows on One AMP for More Efficient Queries

Teradata Statistics Design for High Performance: An Introduction

Learn how Teradata 14.10 simplifies statistics collection for better performance. Discover new features that identify unused and missing statistics.

Teradata Statistics Collection for Improved Query Performance

Learn how to optimize your Teradata queries with statistics collection. Discover what to collect and what to omit for accurate query estimation.