If you have spent any amount of time working with Teradata, you know that the Primary Index is one of the most important design decisions you make. It determines how data is distributed across AMPs and whether your joins are fast or slow. Choosing the wrong Primary Index is one of the most common causes …
Introduction to Teradata Multiload and Fastload
This article will highlight the contrasting architectural features of Teradata and SQL Server, along with their shared aspects and performance impacts. The piece titled “Teradata versus SQL Server” will be periodically updated.
Learn how to optimize load times in Teradata by choosing the correct data types and sizes for stage tables. Read on for a real-life example.
How Advanced Is The Teradata Columnar Solution? A Column Store is defined by three distinct properties: Why Is The Teradata Solution Great Even Though It Does Not Offer Columnar Processing? Assuming a standard query, a date range selection is frequently made with a WHERE condition imposing a date restriction. However, only a portion of the …
Experienced Teradata users are familiar with the concept of a primary index. However, a new term has surfaced with the introduction of Teradata Release 15: Primary AMP Index. This blog post will demonstrate a Primary AMP Index’s benefits and optimal usage for improving load and query performance. First, let us examine Teradata’s approaches over the …
Introduction to Teradata in the Cloud Cloud databases are pressuring traditional data warehousing MPP systems. This blog post will illustrate the reasons for this and outline the pros and cons of each database system. The Architecture of an MPP Database System MPP database systems employ a shared-nothing architecture, wherein each node has its own CPU, …
This post will contrast the architecture of two widely-used database systems. The similarities between Teradata and Amazon Redshift are notable, as much of your knowledge about Teradata can be applied to Amazon Redshift. Although Amazon Redshift stores data in columns permanently, the similarities remain significant. Teradata can store data in columns, though it was not …
Teradata Table Design Checklist As creating tables is a frequent task, I deemed it necessary to provide a checklist. 1. Primary Index Or NOPI Table? The Primary Index serves multiple purposes, primarily functioning as the primary access path to the data and being optimized for an even distribution of rows. However, designing a table without …
The Essential Facts About NOPI Tables in Teradata Teradata NOPI Table Limitations No SET tables allowed No Identity columns allowed No Row-Level Partitioning allowed No UPDATE, MERGE INTO, or UPSERT allowed No Permanent Journaling is possible It can’t be defined as Queue Tables No UPDATE triggers allowed No Hash Index allowed No Multiload, as its …
Expert network for enterprise data platforms. Senior consultants, project teams built for your challenge — across Teradata, Snowflake, Databricks, and more.
📍Vienna, Austria & Jacksonville, Florida
Join 4,000+ data professionals.
Weekly insights on Teradata, Snowflake & data architecture.