327 technical articles on Teradata, Snowflake, Databricks, SQL tuning and data warehouse architecture — written from production experience, not vendor decks.
Discover the importance of Teradata statistics in optimizing query execution plans. Learn how to collect statistics and when to use them for best results.
Turning on the Teradata Locking Loggerby Vasudeva Rao To activate the locking logger, access the DBS console window or cnsterm subsystem and ensure it is enabled. Note that the change will only take effect once the database has been restarted. Below is the dbscontrol help output for the flag that governs the locking logger: 9. LockLogger …
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 …
Use TO_NUMBER to parse numeric text, TRUNC to discard decimal digits, and ROUND to round them. FLOOR and CEILING move toward negative and positive infinity respectively. Those differences matter for negative values. A letter-case comparison is not a numeric validator. Lab check: 24 October 2026 · Teradata 20.00.28.81 · BTEQ 20.00.00.11 · BTET. The values …
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 14.10. Current Database Limits documentation lists maximum non-spool row …
As a Teradata SQL specialist, I find skew to be a common challenge. In fact, approximately 90% of SQL performance difficulties stem from skew, based on my experience. However, this article focuses on the potential for minor modifications to yield significant improvements. This article highlights the potential consequences of selecting inappropriate character sets for SQL …
Learn an unusual trick to improve the performance of joining partitioned tables with different primary indexes or partitioning. Read on to find out more.
Learn about Teradata Utility Workload and its specialized and optimized user requests that are not SQL protocol-based. Explore its protocols and management techniques.
Learn about Teradata Workload and its benefits in this article. Workloads group requests with common characteristics, making it easier to manage them.
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 …
We count visits without cookies and without storing anything on your device. With your permission, we also use Google Analytics for our Google Ads integration and remember which campaign brought you here. We do not record sessions. You can decline and still use the site. Privacy details.
Protected by Security by CleanTalk