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

Icon of a chrome hammer inside an orange circle over a brick pattern

What is a Teradata Macro? A macro executes its statements as a request, with transaction behavior governed by session mode and any enclosing transaction. Do not infer an unconditional commit. Quoting the Subscriber identifier allowed CREATE/REPLACE, EXECUTE and DROP to complete in the fixture. What are the Features of Teradata Macros? How is a Macro …

Read more

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

Illustration of a stopwatch dial on an orange paint-splash background

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 …

Read more

Teradata Architecture: How Shared-Nothing Parallelism Works Widely read

Illustration of three stacked database units of differing heights inside a circle

Teradata Query Parallelism Teradata can execute scans, joins, sorts and aggregations in parallel. The chosen plan determines how many AMPs participate; a primary-index lookup can use one AMP, and dependencies may serialize parts of a request. 🎓 Prefer video? Lecture 2 of my Udemy course Teradata Performance Tuning in Practice, “Shared-nothing parallelism: nodes, PEs and …

Read more

Optimizing Teradata Requests with Group-AMP Operations for Improved Performance

Illustration of a stopwatch dial on an orange paint-splash background

All-AMP describes participating AMPs, not a mandatory full-table or subtable scan. NUSI access can be narrowed by other predicates and maps; inspect the actual access steps. Group-AMP operations optimize requests by minimizing the number of active AMPs. These operations fall between single-AMP and all-AMP operations. The Optimizer employs group-AMP for data retrieval and joins. A …

Read more

Teradata SQL Tuning: How to Optimize Queries for Stable Runtimes Popular

Illustration of a glossy orange database cylinder with data fragments across its surface

Learn how to optimize Teradata SQL Tuning with comprehensive analysis of available tools in this article. Discover the optimal approach for query optimization for both tactical and strategic workloads, as well as methods for eliminating full table scans, reducing skew, and examining the execution plan. Plus, find out how to address common issues like concurrency and misestimation.

Protected by Security by CleanTalk and CleanTalk Anti-Spam