From QueryBand to Query Tag

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

How to Track Query and User Activity After Migrating from Teradata to Snowflake By Roland Wenzlofsky · DWHPro 🎯 Why This Matters In Teradata, QUERY_BAND has long been a hidden gem — the ability to tag every query or session with metadata like App, Job, or UserGroup. That little string became the key to workload …

Read more

Filter efficiently with Teradata NOS Popular

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

Teradata NOS facilitates querying data in an S3 object store with ease. To attain maximum performance, partitioning external data is crucial for efficient reading. This article outlines the key considerations for optimal efficiency when reading data from the object store. Use an authorization method supported by the target object store and database release. The placeholders …

Read more

Teradata strtok_split_to_table, CSVLD, Unpack: Column Splitting in Teradata Widely read

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

Splitting column content can be a challenging task. Teradata provides multiple methods to achieve this, each with unique pros and cons. In this article, we will examine these techniques in detail. To begin, we will generate a table containing sufficient random data to assess every option’s efficiency and resource utilization. The Teradata “CSVLD” Function This …

Read more

A Teradata HASHROW Table Difference Screening Test Popular

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

Have you ever experienced extended waiting times for a table comparison to yield results? Have you ever been compelled to halt and defer quality checks on sizable tables owing to excessive resource utilization during a previous attempt? Hash comparison can be a compact preliminary screen, but it can miss real differences. It must not be …

Read more

SQL Tuning Goals: Improving Performance and Reducing Resource Usage Widely read

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

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.

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

Protected by Security by CleanTalk and CleanTalk Anti-Spam