Performance Tuning
A collection of 267 issues
Teradata Tactical Workload
Introduction
This blog post discusses tactical workloads on a Teradata system. Despite Teradata's implementation of features that support tactical workloads, this workload category remains challenging to manage. Selecting an optimal physical design is essential to meet user expectations for query speed.
Designing the Teradata tactical workload on a
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
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
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
What is Teradata Query Rewriting? Top 6 Optimization Techniques Explained
What is Teradata Query Rewriting?
Teradata query rewriting is an integral component of the optimization process for Teradata.
The optimizer replaces your query with a more efficient and faster version.
Both queries must produce identical results. Teradata implements various optimization techniques to enhance performance.
Want more practical data engineering analysis