327 technical articles on Teradata, Snowflake, Databricks, SQL tuning and data warehouse architecture — written from production experience, not vendor decks.
Teradata SQL Stored Procedures enhance traditional SQL with procedural language features like iterations, condition and error handling, and variables. Learn more here.
Learn about Teradata’s MaxValueLength feature, which allows users to specify how many bytes or characters should be used when creating statistics histograms.
Learn about Teradata’s load utilities, which can be divided into two groups: those that bypass the transient journal and those that use it. Depending on your requirements, you may choose to load data either way. This article offers advice on how and when to use each tool, including BTEQ, TPump, Fastload, Multiload, and the Teradata Parallel Transporter (TPT). Find out which tool is most efficient for your data quantity and row size.
Review prefix predicates and a corrected CASE_N partition example. Partition elimination depends on the plan; the unsafe original procedure is withdrawn.
Explore classic Teradata appliance nodes and their parsing-engine, AMP and BYNET roles. Physical topology differs across deployment types.
Learn how to minimize disk IOs with the Teradata DatablockSize option. Read on for an overview of how it works and how to choose the best size.
Define performance objectives and compare CPU, I/O, spool and elapsed time under controlled conditions. Resource metrics also depend on the environment.
Learn about the different types of access rights in Teradata, including implicit, explicit, inherited, and automatic privileges, and how they are granted to owners and creators of database objects.
Learn how Teradata primary indexes, hashing and table maps determine row placement and access. Balance workload needs, skew and index-value stability.
To gain a comprehensive insight into the operation and performance of your load utilities and DSA jobs, the DBQLogTbl offers a starting point. The DBQLogTbl provides metrics for these utilities, but they are not as accurate or plentiful as those provided by Teradata DBQLUtilityTbl. What is the Teradata DBQL Utility Log? The DBQLUtilityTbl offers a …
We count visits without cookies and without storing anything on your device. With your permission, we also use Google Analytics for our Google Ads integration and remember which campaign brought you here. We do not record sessions. You can decline and still use the site. Privacy details.
Protected by Security by CleanTalk