Transactions Archives - Page 4 Of 5 -

Understanding Teradata Load Isolation

04/11/202604/28/2023 by Roland Wenzlofsky

Isolation Levels and their Impact on Performance & Concurrency Isolation is a crucial factor in determining the visibility of transaction integrity to database users. This property guarantees that concurrently executed transactions produce identical results to those executed sequentially. Nonetheless, relinquishing this requirement can enhance transaction concurrency, improving performance. However, this also implies accepting inconsistent outcomes. …

Teradata Transactions: Main Characteristics and Best Practices

04/11/202604/28/2023 by Roland Wenzlofsky

What Are The Main Characteristics Of Transactions in Teradata? The Teradata Mode For Transactions Various techniques exist for composing SQL statements and applying transaction handling. Each approach has unique benefits, drawbacks, and characteristics worth considering. Let’s examine two sequential statements as an illustration: Using Teradata Mode With Explicit Transaction These statements can be executed as …

Choosing the Right Teradata Data Types

04/11/202604/28/2023 by Roland Wenzlofsky

How Do I Select The Appropriate Data Type In Teradata? Converting datatypes incurs substantial costs and demands significant CPU resources when dealing with extensive tables. Incorrect data type selection hinders the execution plan. This article will discuss selecting appropriate data types for optimal performance. Consistency in selecting data types across different tables is crucial, as …

Unlocking the Power of Teradata Macros: Features, Creation, and Execution

04/11/202604/28/2023 by Roland Wenzlofsky

What is a Teradata Macro? The Teradata macro executes multiple SQL queries in a single transaction, ensuring that all requests are successful or changes to database objects are rolled back. What are the Features of Teradata Macros? How is a Macro created? How is a Macro changed? How is a Macro dropped? How is a …

Teradata Referential Integrity: What it is and Why You Need it for Data Consistency and Performance

04/11/202604/28/2023 by Roland Wenzlofsky

Introduction to Teradata Referential Integrity Teradata implements 3 Types of Referential Integrity. 1. What is Standard Referential Integrity? The Standard Referential Integrity checks every Row INSERT, DELETE, or UPDATE immediately to ensure referential integrity. A reference index sub-table is required for referential integrity. Violation of referential integrity results in the failure of execution and generates …

Maximizing Performance with Multiple Teradata Sessions

03/08/202604/28/2023 by Roland Wenzlofsky

Teradata Sessions explained in a few Sentences Example 1: Multiple Sessions which do not improve performance The graph shows that all four transactions (T1, T2, T3, T4) are concurrently active on all AMPs. Even for a single-row lookup, these transactions necessitate accessing all AMPs. None of the transactions use a single rowhash for access, resulting …

Teradata Table Design Checklist: Primary Index, Character Set, and Data Type Considerations

04/11/202604/28/2023 by Roland Wenzlofsky

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 …

Teradata Query Parallelism: A closer look at how Teradata’s shared-nothing architecture and parallel processing capabilities deliver exceptional performance.

04/11/202604/28/2023 by Roland Wenzlofsky

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 levels of parallelism from the start, even …

Achieve Incredible Teradata Join Performance

04/11/202604/28/2023 by Roland Wenzlofsky

Executive summaryGUEST POST BY ARTEMIY KOZYR Today I shed some light on how Data Warehousing lies at the core of Retail Banking operations. We will see the actual case of vital marketing process malfunction and dive deep under the surface level to comprehend data alchemy technical issues. You will learn how to approach such issues, …

How to Optimize Teradata Statistics and Avoid Heuristics: A Case Study

04/11/202604/28/2023 by Roland Wenzlofsky

The Optimizer typically excels in utilizing statistics, yet examining the execution plan and cardinality estimations can sometimes be beneficial. Since Teradata 14.10, I have habitually included the SHOW STATISTICS statement in my considerations. The resulting metrics can aid in identifying statistical issues. Teradata Statistics – Avoid the Heuristics This case study demonstrates how the Optimizer …