Outsmarting Teradata Limitations: A Workaround for Teradata Identity Columns in Volatile Tables
Learn how to overcome the hurdle of using Teradata Identity columns with Volatile Tables. Discover a workaround using the 'CREATE TABLE AS' statement.
Performance Tuning
A collection of 267 issues
When Teradata Space Shortage Impacts System Performance
Running out of free Cylinders in Teradata
Encountering a situation where free cylinders are exhausted is a significant concern when managing a system, and no more Teradata Space is available. It's an issue that can adversely impact the operations and efficiency of the database, leading to potential slowdowns
The Pitfalls of Teradata SELECT * Queries
Introduction
In a row-oriented database engine like Teradata, data is organized and stored in units called data blocks. Each data block features a fixed header and accommodates multiple rows. Every row consists of a record header followed by its corresponding columns.
When a database retrieves and stores a data block
Improving SQL Performance with Simple Query Rewrites: Dealing with Duplicates and Business Calendars
The Teradata flavor of SQL is still, in principle, a declarative language. Hence, there can be multiple ways to describe an SQL query and achieve the same result. While the answer is the same, Teradata may use a completely different execution plan based on how the query is expressed. One
Improving Stored Procedure Performance with Teradata MAPS Architecture
Effortlessly Loading a CSV File into Teradata using Python
Learn how to easily load a CSV file into a Teradata database using Python with minimal code. No need for complex scripts or ETL tools. Read more.
Negative Impact of Applying Functions to Join Columns in Teradata Joins: Performance Implications and Solutions
Functions on Join Columns and Their Impact on Teradata Performance
In many Teradata systems, developers apply functions directly in join conditions to work around data-model inconsistencies.
While this approach might seem harmless, it can dramatically affect optimizer decisions and query performance — and often reveals deeper data-model issues.
Example of a
Filter efficiently with Teradata NOS
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.
To begin, we must establish S3 access by obtaining an
Teradata TD_WhichMax and TD_WhichMin Functions: A SQL Solution for Finding Min/Max Value of a Column with Low Resource Consumption
Date ranges and business calendars beyond recursion and Teradata SYS_CALENDAR
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 at the expense of single-AMP, single-row access. We can use this approach to build both a wide date range as