DWHPro Insights

join index

Tracking Teradata Statistics Usage with StatUseCountV Popular

Illustration of a person in a suit standing beside a database cylinder

How to find out if the Teradata Statistics we created for a specific workload are used? Teradata statistics greatly affect SQL query efficiency. We need a reliable method to get this information. Various objects, such as tables and join indexes, can have statistics collected on them. As performance tuners, it is important to confirm their …

Read more

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

Illustration of a stopwatch dial on an orange paint-splash background

The DBQL example needs configured logging and a bounded time window. HASHAMP()+1 assumes the relevant map/AMP scope; it may misrepresent a request using only a subset of AMPs. Use the actual participating-AMP count for meaningful skew/impact calculations, and clear temporary query bands after the measured workload. 1. Complete and up-to-date Statistics At the start of …

Read more

Teradata vs SQL Server: Key Architectural Differences and Performance Implications Widely read

Illustration of three stacked database units of differing heights inside a circle

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. For comparisons against other platforms: how Teradata and Amazon Redshift differ and what makes Teradata an RDBMS rather than an appliance. The same …

Read more

High-Performance Calculations with Teradata Ordered Analytical Functions Popular

Illustration of a glossy orange database cylinder with data fragments across its surface

For a true calendar-day window, aggregate to one row per department/day and supply missing dates, or use a date-bounded query. With duplicate dates, add a meaningful tie-breaker for a ROWS frame. Adding an ORDER BY or PARTITION BY column can change the result and must preserve the intended business semantics. Teradata employs two distinct approaches …

Read more

Optimizing Teradata Statements Containing Multiple JOINS

Illustration of a stopwatch dial on an orange paint-splash background

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 plan and monitor query performance and resource …

Read more

Teradata VantageCloud Lake: Architecture and Use Cases Widely read

Illustration of three stacked database storage units of differing heights against abstract chart shapes

Introduction Parallel database architectures have undergone significant advancements over the past four decades, transitioning from shared memory architecture to shared disk architecture and, finally, to the more efficient shared-nothing architecture. Databases designed specifically for cloud environments incorporate elements of shared-disk and shared-nothing architectures. Teradata is a powerful and scalable relational database management system designed to …

Read more

Optimizing Teradata Queries: From No Index to Hashed NUSI Popular

Illustration of a stopwatch dial on an orange paint-splash background

The initial situation without any index In this blog, I will demonstrate how to optimize a query using Teradata’s tools. We will begin with the following test scenario: The data is evenly distributed. To demonstrate the query’s selectivity for the tested indexes we will define later, I assigned a significant portion of rows the same …

Read more

The Importance of Minimizing Teradata I/O: Understanding Logical vs. Physical IOs and Their Impact on Performance

Illustration of a stopwatch dial on an orange paint-splash background

Why is Teradata I/O so crucial? Minimizing Teradata I/O is a crucial aspect of performance tuning. IOs involve transferring data from storage to main memory, which is essential for Teradata to process data. Transferring data to the main memory is significantly slower than accessing data in the main memory or CPU cache. Minimizing IOs can …

Read more

Teradata Columnar Solution: Advantages and Disadvantages Popular

Illustration of three stacked database units of differing heights inside a circle

How Advanced Is The Teradata Columnar Solution? A Column Store is defined by three distinct properties: Why Is The Teradata Solution Great Even Though It Does Not Offer Columnar Processing? Assuming a standard query, a date range selection is frequently made with a WHERE condition imposing a date restriction. However, only a portion of the …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam