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 To avoid syntax errors, tables derived from queries should always be named alias. Here is a derived table example (in parentheses): SELECT * FROM (SELECT MAX(Revenue) FROM Invoices) AS InvoiceRevenue (MaxRevenue); The table is labeled …
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 loading with Fastload or Multiload. Learn about TPump’s performance and limitations, as well as monitoring and error handling. Check out a sample script to get started with Teradata TPump.
Teradata Query Band: Optimizing Query Performance and Tracking Resource Usage
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.
Mastering Teradata Recursive Queries: How to Create and Use Them for Shortest Path Problems
Learn how to create Teradata recursive queries using either the WITH RECURSIVE clause or CREATE RECURSIVE VIEW statement in this guide. Explore a real-world example of finding the shortest paths in a graph through a recursive solution.
Maximizing Efficiency: Teradata vs. Snowflake Partitioning
Learn how Teradata and Snowflake minimize IOs to enhance performance. Teradata uses row partitioning while Snowflake relies on micro-partitions.