Query Optimization
A collection of 72 issues
Skewed Joins, Straight Answers: A Neutral Guide for Snowflake/Teradata Teams
Snowflake’s physical join execution is predominantly hash-based. In practice you’ll observe hash-join variants with two distributions:
* Broadcast hash joins — replicate a small build side to all workers (warehouse nodes) and join locally.
* Partitioned (shuffle) hash joins — repartition both inputs by the join key so matching keys land on
Boost Your Teradata Performance - The Critical Role of NOT NULL Declarations
Introduction to Teradata Performance and NOT NULL
Welcome to our latest Teradata performance blog post, a series designed to provide valuable insights into SQL queries. This article spotlights 'NOT NULL'.
To delve deeper into 'NOT IN', it is crucial to comprehend a frequently neglected SQL database
Improving SQL Performance with Simple Query Rewrites: Dealing with Duplicates and Business Calendars
The Teradata flavor of SQL is still, in principle, a declarative language. Hence, there can be multiple ways to describe an SQL query and achieve the same result. While the answer is the same, Teradata may use a completely different execution plan based on how the query is expressed. One
Negative Impact of Applying Functions to Join Columns in Teradata Joins: Performance Implications and Solutions
Functions on Join Columns and Their Impact on Teradata Performance
In many Teradata systems, developers apply functions directly in join conditions to work around data-model inconsistencies.
While this approach might seem harmless, it can dramatically affect optimizer decisions and query performance — and often reveals deeper data-model issues.
Example of a
Teradata TD_WhichMax and TD_WhichMin Functions: A SQL Solution for Finding Min/Max Value of a Column with Low Resource Consumption
Teradata Join Strategies: How to Optimize Join Operations
Mastering Teradata Performance Tuning
SQL Tuning Goals: Improving Performance and Reducing Resource Usage
Learn about the goals of SQL tuning and how to optimize database performance by reducing resource usage. Skew, IOs, and CPU seconds are key metrics. Discover how to ensure completeness and correctness of Teradata statistics, detect missing and stale statistics, and improve query plans.