Teradata
A collection of 307 issues
Teradata Tactical Workload
Loading Data into Teradata using Python and Fastload
This article assumes prior basic knowledge of Python and demonstrates the easy process of loading data using Python and the Teradata SQL Driver for Python with Fastload.
If you are using Windows, we recommend using WinPython if you don't have Python installed yet. Because a Jupyter Notebook is
Tracking Teradata Statistics Usage with StatUseCountV
How to find out if the Teradata Statistics we created for a specific workload are used?
Teradata statistics greatly affect SQL query efficiency.
We need a reliable method to get this information.
Various objects, such as tables and join indexes, can have statistics collected on them. As performance tuners, it
The Teradata Recursive Query for Performance Tuning
Problem-solving without a Teradata Recursive Query
To depict a corporate hierarchy in our instance, we can employ a non-recursive approach, illustrated by the query presented below:
SELECT
-- Concatenation of all Companies
CASE WHEN Level >= 3
THEN TRIM(t03.Company_Id) || '.' ELSE '' END
|| CASE WHEN
Designing Teradata Row Partitioning for Optimal Performance in Tactical Workloads
How to Load a Flat File into an Empty Table with Teradata TPT: A Simple Example
This article illustrates loading a flat file into an empty Teradata table using TPT. The example was successfully tested on Teradata 16.20.
Although TPT does offer a wide range of advanced options for loading files, it can be overwhelming for basic tasks. In this demonstration, I will present a
The Importance of Up-to-Date Statistics for Teradata SQL Tuning
1. Complete and up-to-date Statistics
At the start of Teradata SQL Tuning, statistics are a vital concern. The Teradata Optimizer employs statistics to formulate the optimal execution plan for our query.
The adequacy of statistics or dynamic AMP sampling varies according to the data demographics.
To initiate optimization, updated statistics
Teradata vs SQL Server: Key Architectural Differences and Performance Implications
This article will highlight the contrasting architectural features of Teradata and SQL Server, along with their shared aspects and performance impacts. The piece titled "Teradata versus SQL Server" will be periodically updated.
Want more practical data engineering analysis like this?
Join DWHPro Letters and get field-tested notes on