The Teradata NESTED join and the impact of the Primary Index
Discover the benefits of using a Teradata NESTED join strategy for economical data joining. Learn how to enable this feature and optimize query design.
The Impact of Skewing on Teradata demonstrated
Learn how skewing on Teradata can impact query run times with this informative test scenario. Find key figures and observations to help optimize your performance.
Teradata Tuning: Fixing The Broken Data Model
Learn about the challenges of Teradata Performance Optimization from an expert. Discover why fixing a poorly designed data model is critical to success.
Column-Oriented Storage in Teradata: A Solution for Big Data Challenges Widely read
Learn about Teradata’s column-orientated storage, which offers an alternative way of laying out data on disks, benefiting data retrieval in Big Data times. This article explains how columnar tables work, how they differ from row-oriented databases, and how you can create them in Teradata 14.00.
Understanding the Relationship Between RDBMS and Hadoop: A Map Reduce Example
Explore a conceptual MapReduce implementation of a join and aggregation, alongside the equivalent SQL result.
Doing Teradata Hashing The Right Way
This article presupposes your existing familiarity with the fundamental structure of a Teradata System. As you are aware, the AMPs operate on a Teradata System. The number of AMPs responsible for managing rows stored on their respective virtual disks varies based on the system’s size. There may be hundreds of AMPs. As noted in my …
Copy a Table Between Teradata Databases: CREATE TABLE AS Popular
Copy tables with Teradata CREATE TABLE AS using WITH DATA or WITH NO DATA. Check target definitions, eligible statistics, privileges and storage requirements.
Evaluating the Accuracy of Table Statistics: Why Collection Date May Not Be Enough
Learn how to accurately evaluate the statistics of a table beyond just the collection date. Find out how to test the validity of your table’s statistics with a simple query.
Teradata Explain Statement: A Guide to Optimizing SQL Performance Popular
What is the Teradata Explain Statement? Optimizing performance can be challenging, often requiring significant effort to identify the root issues. Thankfully, Teradata provides the EXPLAIN statement as a robust tool for assessing the execution of SQL statements. In Teradata, SQL statements are processed in a series of distinct tasks that correspond to specific components of …
Maximizing Performance with Teradata Partitioning Strategies Widely read
Learn about Teradata Partitioning and how it can improve query performance. Discover strategies for using row-level partitioning and considerations before partitioning a table.