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
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
Discover how Map Reduce is becoming a key feature of most database vendors’ RDBMS. Follow an example of SQL aggregation statement joined with two tables.
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 …
Cloning of Tables In Teradata
Learn how to clone tables in Teradata quickly and easily using the CREATE TABLE AS statement. Transfer statistics and definitions without wasting resources.
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
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
Learn about Teradata Partitioning and how it can improve query performance. Discover strategies for using row-level partitioning and considerations before partitioning a table.
Understanding the Teradata Join Index: Benefits, Usage, and Implementation
Learn about the Teradata Join Index, a performance tuning tool that stores pre-joined tables, aggregations, or table content in a different structure. Discover its benefits, what it is used for, and when to use it.