Decomposable Columns: Definition, Impact on Performance, and Workarounds
Learn about decomposable columns, which can be split and lead to better performance for data access. Find out how to optimize their use in this guide.
The Importance of PDM in Database Compression and Resource Usage Optimization
The importance of the PDM Compression is a widely used method for reducing IOs by enabling the accommodation of more rows in each data block. Data blocks are the smallest unit exchanged between hard drives and main memory, which is the most costly operation in any database system. Compression can be automated through block-level compression …
Analyzing and Fixing Teradata Statistics Estimation Problem
Learn how to troubleshoot a statistics problem in Teradata. Discover why estimations for a query can be wrong and how to fix them.
The Importance of Avoiding SQL Functions on WHERE Condition Columns for Optimizer Performance
Learn why it’s important to be careful when applying SQL functions on WHERE condition columns and how it can impact query performance.
Teradata Join Optimization: Early and Partial GROUP BY Techniques for Decision Support Workload
Learn how Teradata applies two effective join optimization methods, Early and Partial GROUP BY, for decision support workloads with lots of aggregations. These transformations reduce resource usage and are widely used in modern databases. Discover how to improve the optimizer’s chance to apply these techniques by collecting statistics on all join and aggregation columns.
Understanding Teradata Value Ordering for Improved Range Scans and Data Retrieval
Learn about Teradata value ordering, an optimization technique for range scans of 32-bit integers. Read on to understand how it is implemented.
Teradata Partitioning: Row vs. Column for Efficient Data Access
Learn about Teradata Partitioning and how row and column partitioning can minimize data access resource usage. Read on for benefits and examples.
Boosting Teradata Statistics Performance with New Syntax in Release 14.00
Discover the improvements for Teradata statistics with the new syntax starting from Release 14.00. Learn how to optimize performance and usage.
Understanding MaxValueLength and Its Importance in Teradata Statistics Popular
Learn about Teradata’s MaxValueLength feature, which allows users to specify how many bytes or characters should be used when creating statistics histograms.
Optimal Performance by Avoiding CHARACTER Columns in the Primary Index
The Teradata Primary Index and Hash Collisions Using either INTEGER or CHARACTER data types for the Teradata Primary Index does not usually impact performance. The hashing algorithm in Teradata is highly efficient. In the rare case where primary index columns from different tables have different CHARACTER SET, there may be minimal performance losses, but this …