Sign in Subscribe

SQL

A collection of 180 issues

The Teradata Recursive Query for Performance Tuning

Problem-solving without a Teradata Recursive Query To depict a corporate hierarchy in our instance, we can employ a non-recursive approach, illustrated by the query presented below: SELECT -- Concatenation of all Companies CASE WHEN Level >= 3 THEN TRIM(t03.Company_Id) || '.' ELSE '' END || CASE WHEN

The Importance of Up-to-Date Statistics for Teradata SQL Tuning

1. Complete and up-to-date Statistics At the start of Teradata SQL Tuning, statistics are a vital concern. The Teradata Optimizer employs statistics to formulate the optimal execution plan for our query. The adequacy of statistics or dynamic AMP sampling varies according to the data demographics. To initiate optimization, updated statistics

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

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

High-Performance Calculations with Teradata Ordered Analytical Functions

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

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.