Introduction to Teradata Nested Join: The Cheapest Join Method Using Indexes
Learn about the Teradata Nested Join, the cheapest join method using indexes. We explore its prerequisites, variants, and performance.
Understanding Teradata’s SAMPLE Function: Randomly Select Rows and More
What is the Teradata Sample Function? The SAMPLE function returns a set of randomly selected rows. Here are the characteristics: The Syntax of the Sample Function SAMPLE [WITH REPLACEMENT] [RANDOMIZED ALLOCATION][WHEN <condition> THEN] {<number of row> | <percentage>} […,<number-of-rows> | <percentage>][ELSE {<number of rows> | <percentage } END] Here are some examples of how to …
Efficiently Load Tables with Teradata Fast Path INSERT/SELECT: Requirements and Advantages
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 mass storage using a single …
Hot Standby Nodes: The Secret to Seamless Performance and Recovery
A hot standby node belongs to a clique of nodes and does not host virtual processes such as AMPs or Parsing Engines. The standby node remains idle until a member of its clique crashes or fails. At this point, the standby node is activated to take over the failed node’s responsibilities. The AMPs from the …
Improving Row Estimates with Teradata Check Constraints
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. …
Optimizing Teradata Joins with Skewed Data: Strategies and Solutions
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 …
Teradata Integrated Workload Management: Features, Classification Criteria, Filters, Throttles, and Workload Priorities
Learn how Teradata Integrated Workload Management assigns workloads to queries and offers features like filters and throttles to improve system performance.
Using Sparse Maps in Teradata 16.10 for Efficient Distribution of Small Tables Across AMPs
Teradata 16.10 introduces Sparse Maps, a feature to place small table rows on one AMP. Learn more about how it can optimize your system here.
Teradata Row Size Limits: Understanding and Overcoming the 3577 Error
Learn about the Teradata row size limits and how to deal with the “3577 Row size or Sort Key size overflow” error in this informative article.
Teradata Data Access: Single-AMP vs. All-AMP Binary Search and Sequential Search
Teradata data access is categorized based on the number of AMPs involved and the technique employed to search rows within a data block. In our article about SQL Tuning, we mentioned that one of the main goals in performance optimization is to distribute the workload evenly across all AMPs. Using a single AMP is best …