Performance Tuning
A collection of 267 issues
Teradata strtok_split_to_table, CSVLD, Unpack: Column Splitting in Teradata
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
Comparing Index Types of SQL Server and Teradata: Clustered vs Row Partitioning, Non-clustered vs NUSI, USI, Join Index, and More
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
The SQL Server's clustered index arranges table rows in a specific physical
How the Number of Rows per Data Block Affects Teradata NUSI Selectivity: A Case Study
Understanding Teradata Statistics Histograms: How the Optimizer Estimates Cardinality for WHERE Conditions
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
Hadoop and Teradata Data Warehousing: A Comparison and Integration Perspective
Hadoop is a buzzword in the world of big data, but its actual value can be concealed by the hype. This article compares Teradata and Hadoop Data Warehousing, highlighting the advantages of leveraging Hadoop's scalability and preprocessing capabilities to improve Teradata's performance. However, the
A Teradata HASHROW Table Difference Screening Test
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?
What if you possessed a straightforward screening test indicating which tables require further
Layer and Preparatory Table Strategies
Typically, query tuning involves altering the composition of various objects.
An alternative method for achieving quicker results, in cases where modifying SQL, is not feasible or has already been completed, involves substituting the objects from which data is retrieved. By incorporating intermediate objects into a daily job chain, numerous queries