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 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

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

Understanding Teradata Hash Collisions – A Case Study Widely read

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

To comprehend the issue of Teradata hash collisions, I will briefly explain how rows are allocated. If you are unfamiliar with Teradata Architecture or require a refresher, I suggest reading the following article beforehand: As you know, a hashing algorithm distributes a table’s rows to the AMPs. The Foundations The hashing algorithm accepts one or …

Read more

Advanced GROUPING Methods in Teradata SQL: GROUP BY GROUPING SETS, ROLLUP, and CUBE Popular

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

Teradata SQL and Advanced GROUPING Functions The advanced GROUPING functions will be demonstrated through the following example. The foundation of this demonstration is a table consisting of the flight count for each aircraft and date: CREATE MULTISET TABLE Flights ( PLANE BIGINT NOT NULL, FLIGHTDATE DATE NOT NULL, NR_FLIGHTS INTEGER NOT NULL ) PRIMARY INDEX …

Read more

Optimizing Teradata System Performance: Identify and Improve Resource-Consuming Queries

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

This query analyzes DBQL query records, not individual execution steps. It requires populated logging data. HASHAMP()+1 is only appropriate when it matches the participating-AMP scope; adapt that input for maps and restricted-AMP work. Ties in Wasted_CPU need a stable query identifier for reproducible ranks. Zero total waste returns NULL rather than a percentage. Improve the Performance of …

Read more

Achieve Incredible Teradata Join Performance

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

Executive summaryGUEST POST BY ARTEMIY KOZYR Today I shed some light on how Data Warehousing lies at the core of Retail Banking operations. We will see the actual case of vital marketing process malfunction and dive deep under the surface level to comprehend data alchemy technical issues. You will learn how to approach such issues, …

Read more

Learn Essential Teradata SQL Statements and Functions for Data Warehousing and Analytics Widely read

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

Learn the most essential Teradata SQL statements and functions in this article. From CREATE TABLE to Teradata-specific hashing functions, enhance your data manipulation and analysis capabilities on the platform. Whether you’re a beginner or an experienced user, this guide will help you master Teradata SQL skills.

Maximizing Teradata Table Performance with BLC, Row-Level Partitioning, and Data Block Size Tuning Popular

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

BLC, Row Level Partitioning, and Datablock Size Tuning The sizes and diagrams below are historical observations: the original data, allocation and effective BLC policy are unavailable, so they have not been reproduced. In this article, we will learn how block-level compression, row-level partitioning, and selection of the appropriate data block size can be used to …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam