Method 1, avoiding any helper tables or functions which are only available in new releases of Teradata: Method 2, with helper tables and XMLAGG: Both methods deliver the string “1,2,3,4,5,6,7,8,9,10”. Which process do you believe is using fewer Disk IOs and CPU resources?
Have you observed the different behavior of the Teradata LIKE operator when applied to a CHAR or VARCHAR data type column? Consider the following table as an illustration: Creating a table: To illustrate, we will add a single row. We will run the SQL statement for the column with the VARCHAR data type. Next, we …
Teradata SQL and Advanced GROUPING Functions The advanced GROUPING functions will be demonstrated through the following example. The foundation of this demonstration is a table consisting of the flight count for each aircraft and date: CREATE MULTISET TABLE Flights ( PLANE AS BIGINT NOT NULL, FLIGHTDATE AS DATE NOT NULL, NR_FLIGHTS INTEGER NOT NULL ) …
This course focuses on Teradata indexing techniques. In this two-hour video, you will learn about Teradata’s architecture and Full Table Scans, different types of Primary Index Access such as UPI and NUPI, diverse Secondary Index Access including USI and NUSI, and Join Indexes. You will gain the comprehensive knowledge required to create an ideal indexing …
Learn how Teradata stores dates internally as INTEGER values and how to efficiently calculate dates after 1900-01-01 using a simple formula. Get more useful Teradata date calculations in this article.
Teradata UNION ALL – The New Features of Release 16 Teradata 16 introduces new features for UNION ALL queries that can enhance their performance, although their application is not guaranteed. The Optimizer will opt for executing the query through conventional methods if the cost estimations for the traditional execution plan are lower. It is crucial …
TO_NUMBER I have often needed a function to verify whether a character column contains a numeric value. Typically, I have resorted to using a workaround, such as: CASE WHEN UPPER(‘12.77’) = LOWER(‘12.77’) THEN ‘IS_NUMERIC’ ELSE ‘IS_NOT_NUMERIC’ END Naturally, this workaround is limited and cannot manage certain situations, such as consecutive special characters. With the introduction …
Teradata administrators worldwide face similar challenges. I propose creating a worldwide database containing the characteristics of Teradata systems. This will allow for easy comparison and analysis of performance issues between different systems. My initial report displays the CPU idle time and the number of disk I/O waits for every hour throughout the day. To contribute …
Introduction to Teradata Recursions To link records from a primary table with a specific date range from a secondary table, a common requirement is to create a simulated history table with snapshot dates using a change history table with defined timelines. Consider the following illustration: The proposed solution would resemble this: You must create your …
Learn how the CHAR2HEXINT function helped solve a real-world problem of extracting number parts from a string in Teradata SQL. Read on for the solution.
Expert network for enterprise data platforms. Senior consultants, project teams built for your challenge — across Teradata, Snowflake, Databricks, and more.
📍Vienna, Austria & Jacksonville, Florida
Join 4,000+ data professionals.
Weekly insights on Teradata, Snowflake & data architecture.