Learn how to use compression as a table column addition to manage your data warehouse’s space effectively. Discover constraints and best practices.
Teradata offers various options for designing Partitioned Primary Index Tables. The optimal design choice depends on the anticipated workload. This article examines the impact of partitioning methods on the access path selected by the Teradata Optimizer, ultimately influencing system performance. To begin, a test scenario is required, which consists of two identical tables. The sole …
Learn about the Teradata Nested Join, the cheapest join method using indexes. We explore its prerequisites, variants, and performance.
Fast Path INSERT/SELECT efficiently loads a single table. Requirements for Teradata Fast Path INSERT /SELECT How does the Fast Path INSERT/SELECT work? This reduces access to mass storage (such as hard disk or solid-state disk). The process involves generating complete data blocks on every AMP and subsequently transferring them to the mass storage using a …
Without Teradata CHECK Constraint When a non-indexed column is utilized in a retrieval operation (i.e. WHERE statement) and lacks Teradata Check Constraints, the Optimizer employs heuristics to approximate the number of rows in the resulting set by inferring missing statistics. The estimated number of rows is 7,342, equivalent to 10% of the table’s total rows. …
Skewed Teradata Joins – The Initial Situation Consider the scenario where one table includes various currencies while the other comprises customers’ accounts with their corresponding currency. Essentially, the ISO code of the currency serves as a foreign key in the account table. CUSTOMER TABLE CUSTOMER_ID CUSTOMER_NAME CURRENCY_CD 1 Nina Lowery EUR 2 Alexia Neal USD …
Learn about heuristics in Teradata optimizer and how they estimate the number of selected data rows for nonindexed columns in WHERE condition predicates. This post analyzes several queries and their estimates based on heuristics and provides insights on how to replace heuristic estimations with more accurate ones.
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.
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.