Roland Wenzlofsky
Teradata 16 Introduces New Features for UNION ALL Queries
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
Teradata Built-In Functions: TO_NUMBER, TRUNC, CEILING, FLOOR, LEAST, GREATEST, ROUND
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&
Introduction to Teradata Big Data Blocks: Advantages and Disadvantages
Teradata Big Data Blocks - Introduction
Teradata 13.10 introduced larger file systems components, such as cylinders and data blocks. The cylinder size was increased from 1.9 MB to 11.3 MB, while the data block size limit was raised from 127.5 KB to 1 MB in Teradata
The Impact of Character Sets on Teradata SQL Performance: A Case Study
How to Join Partitioned Tables with an Unusual Trick for Improved Performance
Learn an unusual trick to improve the performance of joining partitioned tables with different primary indexes or partitioning. Read on to find out more.
Teradata Utility Workload Management: Overview and Protocols
Learn about Teradata Utility Workload and its specialized and optimized user requests that are not SQL protocol-based. Explore its protocols and management techniques.
Understanding Teradata Workload: Definition, Advantages, and Characteristics
Learn about Teradata Workload and its benefits in this article. Workloads group requests with common characteristics, making it easier to manage them.
Global Teradata System Characteristics Database: Help Us Build It!
Teradata Statistics Extrapolation: What it is and How it Works
Learn about Teradata Statistics Extrapolation, a technique that allows for reasonable estimations when querying historical data with stale statistics.