Natural skew may hinder join performance, but the PDPR capability in Teradata 14 can alleviate this problem. However, PDPR may not detect all potential applications if skewed values are not evident in the statistics. If your Teradata version is below 14, PDPR is unavailable. To address this, you can utilize a technical method using the …
Learn how to optimize Teradata performance with these general tuning ideas. From changing one parameter at a time to testing on the target system.
The Teradata NUSI is an alternative access path to table rows, similar to other relational database indexes. Indexes are used to minimize resource consumption, especially IOs. Unlike Oracle, Teradata employs a hashing method for indexing, which is a common method for shared-nothing database systems. Amazon Redshift and Postgres-based database systems also utilize hashing. Teradata has …
Learn about the benefits of partitioned primary index (PPI) in Teradata, a method for reducing I/Os and improving performance in database systems.
Learn about the latest improvements in Teradata 14.00 that allow you to customize the collection of statistics to better suit your needs. These improvements include the option to set different sample sizes, consider more bytes for histogram creation, and choose the number of intervals for building statistics histograms. Read on to discover how these changes can benefit your optimization efforts.
Block Level Compression (BLC) is a feature that allows compression of entire data blocks, leading to disk space reduction. Read on to know more.
Learn about the Teradata Hash Index, designed to minimize disk IOs and improve access to rows. Discover how it differs from Single Table Join Indexes.
Learn how to optimize SQL tuning on Teradata by minimizing I/Os and maximizing parallelism, which can be achieved by evenly distributing rows across all AMPs.
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 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 tiniest entity 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 …
Expert network for enterprise data platforms. Senior consultants, project teams built for your challenge — across Teradata, Snowflake, Databricks, and more.
📍Vienna, Austria & Miami, Florida
Join 4,000+ data professionals.
Weekly insights on Teradata, Snowflake & data architecture.