Roland Wenzlofsky
Maximizing Performance with Multiple Teradata Sessions
7 Deadly Sins That Destroy A Teradata Data Warehouse
To exemplify the impact of mistakes in Teradata Data Warehouse projects, consider the analogy of a medical team. Imagine yourself as the project, preparing for a crucial and costly procedure. Naturally, you wouldn't want to hear the staff engage in the following conversations before administering the anesthesia.
1.
Teradata Table Design Checklist: Primary Index, Character Set, and Data Type Considerations
Teradata Table Design Checklist
As creating tables is a frequent task, I deemed it necessary to provide a checklist.
* Primary Index or NOPI?
* Is the Primary Index distributing rows evenly?
* Is the correct character set used?
* Are character sets and data types matching across tables?
* Can the Primary Index be
Teradata Query Parallelism: A closer look at how Teradata's shared-nothing architecture and parallel processing capabilities deliver exceptional performance.
Teradata Query Parallelism
A query on a Teradata system runs in parallel at every step, whether for joining, sorting, or aggregating data.
Teradata's uniqueness lies in its ability to apply parallelism at every step of the query process. This advantage resulted from its architectural design, which integrated high
The Importance of Teradata Surrogate Keys
Two Methods for Generating Number Ranges in Teradata
Method 1, avoiding any helper tables or functions which are only available in new releases of Teradata:
WITH RECURSIVE NumberRanges(TheNumber,TheString) AS
(
SELECT 1 AS TheNumber,casT(1 as VARCHAR(500)) as TheString
FROM
(
SELECT * FROM (SELECT NULL AS X) X
) DUMMYTABLE
UNION ALL
SELECT
TheNumber + 1 AS TheNumber,
Understanding Partial Group By: Reducing Join Costs with Aggregation Optimization
What is Partial Group By?
Joins are costly. Before the introduction of PARTIAL GROUP BY, the join would be performed first, and then the aggregated result would follow.
PARTIAL GROUP BY reduces the amount of data that must be redistributed or duplicated to all AMPs during join preparation by performing