Sign in Subscribe

Teradata

A collection of 307 issues

Understanding the Teradata Join Index: Benefits, Usage, and Implementation

Learn about the Teradata Join Index, a performance tuning tool that stores pre-joined tables, aggregations, or table content in a different structure. Discover its benefits, what it is used for, and when to use it.

Teradata Stored Procedures & Error Handling: A Guide for Effective Programming

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!

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!

Maximizing Efficiency: How Teradata MAPS Feature Minimizes Downtime and Simplifies Table Distribution

Teradata's MAPS Feature allows for hardware expansion with minimal downtime by delaying table redistribution. Learn how to use MAPS INSERT. SELECT here.

Optimizing Performance with Teradata Summary Statistics

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

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

Introduction to Teradata Temporary Tables This article highlights the distinct types and uses of Teradata temporary tables. 1. Derived Tables * Are materialized by a select statement within a query * Only exist within the time the query is executed * Use the spool space of the executing user * Disappear at the moment

Understanding Cursors in Teradata SQL Stored Procedures: Definition, Usage, and Syntax

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

Discover Teradata TPump, the real-time loading tool for transactional systems. TPump loads one row at a time, allowing concurrent INSERTs and UPDATEs using row hash locks. With TPump, you can throttle statement rates and execute DML functions, all while bypassing some of the limitations of bulk load