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,…
Read article →
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…
Read article →
“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…
Read article →
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…
Read article →
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…
Read article →
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…
Read article →
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…
Read article →
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…
Read article →