Architecture
A collection of 111 issues
Teradata Referential Integrity: What it is and Why You Need it for Data Consistency and Performance
Introduction to Teradata Referential Integrity
What is Teradata Referential Integrity?Referential integrity ensures that a value created in a foreign key (FK) column of a referencing (child) table also exists as a primary key (PK) in the referenced (parent) table. The parent table's column does not have to
Teradata Query Parallelism: A closer look at how Teradata's shared-nothing architecture and parallel processing capabilities deliver exceptional performance.
Teradata Query Parallelism
A query on a Teradata system runs in parallel at every step, whether for joining, sorting, or aggregating data.
Teradata's uniqueness lies in its ability to apply parallelism at every step of the query process. This advantage resulted from its architectural design, which integrated high
Understanding Partial Group By: Reducing Join Costs with Aggregation Optimization
Optimizing Teradata System Performance: Identify and Improve Resource-Consuming Queries
Teradata Priority Scheduler and Resource Allocation Rules
Learn about Teradata's priority scheduler and how resources are allocated across workloads and requests in this detailed guide on workload management.
How to Find ASCII Code of a Character Using Teradata SQL
This course focuses on Teradata indexing techniques.
In this two-hour video, you will learn about Teradata's architecture and Full Table Scans, different types of Primary Index Access such as UPI and NUPI, diverse Secondary Index Access including USI and NUSI, and Join Indexes.
You will gain the comprehensive
How to Improve Cardinality Estimations in Teradata: The Optimizer's Toolkit
Learn about Teradata Heuristics and Optimizer's approach to estimating cardinality for non-indexed columns in this article. Discover how skew improves estimations and why heuristics should be avoided.
Is Teradata Compression Worth Your Time and Effort?
Teradata DBMS offers various compression options to save disk space and improve performance. But, the cost of implementing the compression takes man-time. This article discusses the cost vs. benefit of compression and suggests carefully considering the compression setting when designing new or modif
Introduction to Teradata Big Data Blocks: Advantages and Disadvantages
Teradata Big Data Blocks - Introduction
Teradata 13.10 introduced larger file systems components, such as cylinders and data blocks. The cylinder size was increased from 1.9 MB to 11.3 MB, while the data block size limit was raised from 127.5 KB to 1 MB in Teradata