How to Reduce Skew in Teradata Joins Using the RANDOM() Function Popular

Illustration of a stopwatch dial on an orange paint-splash background

Natural skew may hinder join performance, but the PRPD capability in Teradata 14 can alleviate this problem. However, PRPD may not detect all potential applications if skewed values are not evident in the statistics. If your Teradata version is below 14, PRPD is unavailable. To address this, you can use a technique based on the …

Read more

The Teradata NUSI (Nonunique Secondary Index) Widely read

Illustration of a stopwatch dial on an orange paint-splash background

A Teradata NUSI offers an alternative access path that may reduce resource use. Distribution hashing in another product, such as Redshift, is not evidence that it implements Teradata-style secondary indexes. Teradata has two types of secondary indexes: the Unique Secondary Index (USI) and the Non-Unique Secondary Index (NUSI). Although they may seem similar, these indexes …

Read more

The Importance of PDM in Database Compression and Resource Usage Optimization

Illustration of a stopwatch dial on an orange paint-splash background

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 …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam