Learn about referential integrity and how it ensures data consistency in databases. Discover soft referential integrity and its use in inner join elimination.
Learn how to optimize joins in Teradata with this case study. Discover how simple changes in query text can improve query performance.
Learn how biased value histograms store exact cardinalities and provide up-to-date statistics for queries, and witness how the Optimizer estimates the number of rows for a given query.
Learn how query rewriting can improve performance in row partition elimination. Follow the test setup to optimize the retrieval of rows from a table.
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 analyze workload in Teradata using the DBC.ResUsageSAWT table. This guide explores the essential columns and measures to consider.
Learn how express requests work in Teradata, bypassing stages like syntax checking and permission checking, and how Teradata 14.10 offers a new feature to expedite them.
Learn how to optimize Teradata performance with these general tuning ideas. From changing one parameter at a time to testing on the target system.
To optimize Teradata SQL performance, it is crucial to identify the root cause of any issues. The SQL statement itself is typically not the culprit but rather one or more stages of the execution plan. This article does not cover genuine optimization techniques. Instead, it presents a pragmatic method for query optimization. I have noticed …
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 …
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.