Optimal Performance by Avoiding CHARACTER Columns in the Primary Index Widely read

Illustration of a stopwatch dial on an orange paint-splash background

The Teradata Primary Index and Hash Collisions Primary-index data types, character sets and collations can materially affect hashing, comparison and join conversions. Choose types for correct business semantics and compatible joins; benchmark relevant access paths before changing them. This article addresses a performance issue with CHARACTER columns in the primary index. Although not as apparent …

Read more

Teradata Viewpoint: Diagnose Slow and Waiting Queries Most read

Illustration of a person in a suit standing beside a database cylinder

What is Teradata Viewpoint? Teradata Viewpoint is a browser-based monitoring and administration interface built from portlets. For query diagnosis, its value is connecting a late report to a session, its current state and the evidence needed for the next investigation. Available systems, portlets and actions depend on your installation and assigned roles. Worked example: investigate …

Read more

Teradata CEILING Function: Syntax and Examples Popular

Illustration of a glossy orange database cylinder with data fragments across its surface

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 that takes a numeric value …

Read more

Learn Essential Teradata SQL Statements and Functions for Data Warehousing and Analytics Widely read

Illustration of a glossy orange database cylinder with data fragments across its surface

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 Teradata SQL skills.

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

Icon of a chrome hammer inside an orange circle over a brick pattern

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 feature of the Teradata database …

Read more

Teradata SQL Tuning: How to Optimize Queries for Stable Runtimes Popular

Illustration of a glossy orange database cylinder with data fragments across its surface

Learn how to optimize Teradata SQL Tuning with comprehensive analysis of available tools in this article. Discover the optimal approach for query optimization for both tactical and strategic workloads, as well as methods for eliminating full table scans, reducing skew, and examining the execution plan. Plus, find out how to address common issues like concurrency and misestimation.

Protected by Security by CleanTalk and CleanTalk Anti-Spam