Teradata Identity Columns: Features, Benefits, and Syntax
Learn about the features and benefits of Teradata Identity Columns, and why they are used for transactional and bulk inserts. Discover the data types, syntax, and more.
Indexing
A collection of 141 issues
Why Selecting Only Needed Columns Boosts Performance: Teradata Query Example
Learn why selecting only necessary columns can improve query performance. This article includes an example query and execution plan analysis.
Optimizing the Tactical Workload in Teradata: Skills and Tools Needed
Learn about tactical workload tuning in Teradata, which requires unique skills and tools. This article covers the skills needed to optimize tactical queries and highlights the difference between tactical and decision support workloads. Discover the Tactical Workload Toolkit and how to use join index
The Vulnerability of Outer Joins in Business Intelligence Tools: A Simple Test Scenario
Learn why business intelligence tools often use outer joins and why they can be vulnerable to skewing. Read on to understand the details and risks involved.
Learn Essential Teradata SQL Statements and Functions for Data Warehousing and Analytics
Learn the most essential Teradata SQL statements and functions in this article. From CREATE TABLE to Teradata-specific hashing functions, enhance your data manipulation and analysis capabilities on the platform. Whether you're a beginner or an experienced user, this guide will help you master Terada
Teradata vs. Snowflake: Differences in Architecture
Discover the key architectural differences between Teradata and Snowflake in this informative article. Learn about data distribution, scalability, indexes, workload management, SQL tuning, and more. Read on to find out if Snowflake could be the right fit for your data needs.
Teradata Skewing: Causes, Detection, and Solutions
Learn how to detect and prevent Teradata skewing, one of the main causes of slow query performance. Discover the different types of skew and how to analyze tables, joins, and column values to detect and resolve issues. With practical tips and example queries, this article is a must-read for performa
Improving Teradata Load Performance: Choosing the Right Loading Method
Learn how to optimize your Teradata Load Performance by choosing the right loading method per table. Bulk loads for large tables and transactional loads for small ones. Find out more in this article.
Teradata vs Snowflake: A Comparison of Volatile and Temporary Tables
Introduction to Teradata Volatile Tables and Snowflake Temporary Tables
Teradata and Snowflake offer temporary tables. This post will compare and contrast the types of tables available on each platform.
We will examine table types found only in Teradata and Snowflake and show their ideal use cases.
What is the equivalent
Efficiently Adding New Partitions to a Row Partitioned Teradata Table: A Comparison of Alter Table vs Insert Select
Learn how to efficiently add new partitions to a Row Partitioned Table. We compare two methods, ALTER TABLE and INSERT…SELECT, with test results.