Teradata applies two very effective join optimization methods for decision support workload, which usually is involving a lot of aggregations: Teradata GROUP BY-  Early ...

Teradata Join Optimization: Early and Partial GROUP BY Techniques for Decision Support Workload

  Characteristics of Static SQL The SQL statement code cannot be changed during the Stored Procedure execution. Variables and parameters ...

Static and Dynamic SQL Characteristics: Examples and Differences

  When Teradata Indexing fails Selecting rows from extensive tables with billions of entries can be resource-intensive. While it may ...

How to Avoid Full Table Scans When Using LIKE Operators in Teradata Indexing

  What Are Teradata SQL Stored Procedures? Teradata Stored Procedures are essentially SQL with added functionality found in traditional procedural ...

Teradata SQL Stored Procedures: Adding Procedural Functionality to Your RDBMS

Teradata Partition Elimination – the Stored Procedure Approach Occasionally, we may want to choose rows in a table’s character column ...

Improve Performance with Teradata Partition Elimination: The Stored Procedure Approach

Teradata SQL is a powerful language for querying and manipulating data within the Teradata database environment. As a popular and ...

A Guide to Teradata SQL: Features, Optimization, and Queries

Are you familiar with the Teradata OLAP Functions in your data warehouse applications? Have you encountered a request to utilize ...

Teradata OLAP Functions: A Systematic Approach to Understanding Window Aggregates

What are the Features of the Teradata Identity Columns? What is a Teradata Identity column? The Teradata identity columns feature ...

Teradata Identity Columns: Features, Benefits, and Syntax

Learn the benefits of choosing necessary columns for optimal performance. Our query in question involves a join between two specified ...

Why Selecting Only Needed Columns Boosts Performance: Teradata Query Example

This article presents a case study from my previous projects. Specifically, it showcases an implementation that generates rows for all ...

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