Understanding the Relationship Between RDBMS and Hadoop: A Map Reduce Example
Discover how Map Reduce is becoming a key feature of most database vendors' RDBMS. Follow an example of SQL aggregation statement joined with two tables.
SQL
A collection of 180 issues
Cloning of Tables In Teradata
Learn how to clone tables in Teradata quickly and easily using the CREATE TABLE AS statement. Transfer statistics and definitions without wasting resources.
Evaluating the Accuracy of Table Statistics: Why Collection Date May Not Be Enough
Learn how to accurately evaluate the statistics of a table beyond just the collection date. Find out how to test the validity of your table's statistics with a simple query.
Teradata Explain Statement: A Guide to Optimizing SQL Performance
What is the Teradata Explain Statement?
Optimizing performance can be challenging, often requiring significant effort to identify the root issues. Thankfully, Teradata provides the EXPLAIN statement as a robust tool for assessing the execution of SQL statements. In Teradata, SQL statements are processed in a series of distinct tasks that
Maximizing Performance with Teradata Partitioning Strategies
Learn about Teradata Partitioning and how it can improve query performance. Discover strategies for using row-level partitioning and considerations before partitioning a table.
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.
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.
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