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

Date ranges and business calendars beyond recursion and Teradata SYS_CALENDAR Popular

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

In a previous article, Roland explained how to use recursion to build a data range without touching a physical table. This time, we explore an alternative approach that avoids recursion using a one-row metadata source whose AMP access depends on the plan. We can use this approach to build both a wide date range and …

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

Comparing Index Types of SQL Server and Teradata: Clustered vs Row Partitioning, Non-clustered vs NUSI, USI, Join Index, and More

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

This article compares the index types in SQL Server and Teradata. It can benefit those transitioning between the two platforms to understand their distinctions and overlaps, despite their different architectures. Clustered Index vs Teradata Row Partitioning SQL Server clustered indexes store the table rows at the B-tree leaf level. Range seeks and Teradata partition elimination …

Read more

A Beginner’s Guide to Teradata Multiload and Fastload Most read

Icon of a chrome hammer inside an orange circle over a brick pattern

Introduction to Teradata Multiload and Fastload MultiLoad does not run in isolation: how the utilities are throttled as a workload of their own and the smaller-volume alternative in BTEQ. Next steps Next: query logging Review: SET and MULTISET tables Return to the Teradata learning path

How the Number of Rows per Data Block Affects Teradata NUSI Selectivity: A Case Study

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

The historical threshold and performance results below have not been reproduced on the current release. A 20,000-row functional check confirmed that the former decimal literals 19.332 and 19.333 both selected only integer keys through 19, while 19332 selected keys through 19,332. The SQL cutoffs have been corrected. Teradata NUSI Selectivity and Data-Block Density The goal …

Read more

Understanding Teradata Statistics Histograms: How the Optimizer Estimates Cardinality for WHERE Conditions

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

Teradata Statistics Histograms – A Short Introduction Many are familiar with the Optimizer’s statistical confidence levels. I was recently surprised to discover that a “high confidence” rating does not guarantee a fully accurate estimation (provided the statistics collected are not stale). While I remain hopeful that my observations may be attributed to a bug, I wanted …

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

Protected by Security by CleanTalk and CleanTalk Anti-Spam