SQL
A collection of 180 issues
The Importance of Up-to-Date Statistics for Teradata SQL Tuning
Teradata vs SQL Server: Key Architectural Differences and Performance Implications
This article will highlight the contrasting architectural features of Teradata and SQL Server, along with their shared aspects and performance impacts. The piece titled "Teradata versus SQL Server" will be periodically updated.
Want more practical data engineering analysis like this?
Join DWHPro Letters and get field-tested notes on
What is Teradata Query Rewriting? Top 6 Optimization Techniques Explained
What is Teradata Query Rewriting?
Teradata query rewriting is an integral component of the optimization process for Teradata.
The optimizer replaces your query with a more efficient and faster version.
Both queries must produce identical results. Teradata implements various optimization techniques to enhance performance.
Want more practical data engineering analysis
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
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 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.