Teradata Join Index: Types, Examples and EXPLAIN Widely read
Test Teradata single-table, multi-table and aggregate join indexes with runnable SQL, verified EXPLAIN plans, maintenance checks and troubleshooting guidance.
Teradata Stored Procedures & Error Handling: A Guide for Effective Programming Widely read
Learn how to handle errors in Teradata Stored Procedures. Error handlers provide event-driven functionality and make error handling more efficient.
Never Again “No More Room In Database”. I’ll Show You How! Most read
Discover the exciting new features of Teradata Version 16.00, which can significantly improve data warehouse administration and loading. Learn how to avoid error messages and manage skewed tables with the new Global Space Soft Limit and SKEW features.
Streamline Your Tasks with Teradata Macros: Reusable Blocks of SQL Code for Improved Efficiency
Learn how Teradata macros can improve your database efficiency with reusable blocks of SQL code. Create macros once, execute them anytime!
Optimizing Performance with Teradata Summary Statistics Widely read
Discover how Teradata summary statistics provide valuable information about the number of rows in a table, helping to optimize performance tuning.
Teradata Primary and Secondary Index: Understanding the Differences and Importance for Performance Tuning Popular
Learn about the Teradata Primary Index and how it differs from a primary key. Discover the benefits of defining a primary index and how many can be created per table.
Teradata Temporary Tables: A Guide to Derived and Volatile Tables Popular
Introduction to Teradata Temporary Tables This article highlights the distinct types and uses of Teradata temporary tables. 1. Derived Tables To avoid syntax errors, tables derived from queries should always be given an alias. Here is a derived table example (in parentheses): Create temporary-table DDL before beginning the BTET data transaction; do not mix the …
Understanding Cursors in Teradata SQL Stored Procedures: Definition, Usage, and Syntax Popular
Learn about Cursors in Teradata SQL stored procedures, which are used to iterate over result sets for record-oriented data processing with SQL. Find out why they are necessary and the different types of cursor declarations available.
Teradata TPump: What it is and How it Facilitates Real-Time Data Updates Most read
Learn how TPump performs transactional INSERT, UPDATE, DELETE and upsert operations using packed requests. The historical script is incomplete and is not a runnable control job.
Teradata Query Band: Optimizing Query Performance and Tracking Resource Usage Widely read
Learn what a Teradata Query Band is and how it can be used to optimize queries in a Teradata system. Discover how to set, update, and read query bands, and how to use them for performance tuning. Find out what to consider when creating a query band in Teradata.