Sign in Subscribe

Performance Tuning

A collection of 267 issues

Mastering the Teradata CEILING Function

Introduction To round up decimal values in Teradata, use the CEILING function. It is efficient and accurate. This blog post will show how to use the CEILING function in Teradata to simplify data processing tasks. Understanding the Teradata CEILING Function The CEILING function in Teradata is a built-in mathematical function

Understanding the Teradata TRIM Function: A Guide to Removing Spaces and Characters from Strings

Learn how to improve your data quality and consistency with the Teradata TRIM function. Remove unwanted spaces and characters for more accurate analysis.

How to Use the Teradata CURRENT_DATE Function for Efficient Querying

Learn how to enhance the efficiency and potency of Teradata queries using the CURRENT_DATE function. Discover how to filter data and calculate time intervals with ease.

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

Unlock the Power of Distributed Queries with Teradata Querygrid: Benefits and How-to Guide

Teradata Querygrid is a Teradata database management system component that enables users to retrieve data from various sources and conduct distributed queries. This article examines the Teradata Querygrid concept, its advantages, and its application in accessing and querying data from heterogeneous sources. What is Teradata Querygrid? Teradata Querygrid is a

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

Teradata Transient Journal: How It Protects Transactions Against Failures and Deadlocks

Learn about the Teradata Transient Journal, a crucial component for ensuring data integrity and protecting against system failures. This dictionary table is managed by each AMP, containing rows copied before changes are made to a transaction. If a transaction fails, the journal is used to roll back

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 Architecture: The Pioneer of Data Warehousing

Learn about the basics of Teradata architecture and why it's still a top RDBMS for Data Warehousing. Discover how the system is built for parallelism and how hashing algorithms help distribute data evenly among AMPs. Explore the essential roles of Parsing Engines, AMPs, and Nodes in executing instru

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.