Sign in Subscribe

SQL

A collection of 180 issues

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 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.

Optimizing Performance in Teradata with DIAGNOSTIC HELPSTATS ON FOR SESSION Command

What is the DIAGNOSTIC HELPSTATS ON FOR SESSION Command in Teradata? Gathering statistics is a crucial aspect of optimizing performance. Collecting statistics requires resources, and it matters whether they are used only once in the ETL process or cover multiple queries' workloads simultaneously. Fortunately, Teradata's recent versions

How to Export and Upload Teradata Tables with TPT Scripts: A Guide

Learn how to export and upload tables using Teradata TPT scripts with bulk loading. Check out our example and recommended load methods here.

A Guide to Using Teradata TO_CHAR Function for Type Conversions and Handling Statistics

The Teradata TO_CHAR Function Utilize the Teradata TO_CHAR function to: * Convert numeric expressions to character strings * Convert dates, times, interval data types, or timestamps to character strings This is an example of a numeric expression argument, which can be any of the following data types: BYTEINT, SMALLINT, INTEGER,

5 Tips for Optimizing Teradata SQL Queries: Avoiding Joins, Functions, Union, and Group By

Is Teradata-Specific SQL different from SQL?While the SQL Teradata uses is a dialect of SQL, there are some differences compared to ANSI SQL. It is specifically designed for the Teradata architecture, focusing on parallel processing and scalability. While it supports most of the standard SQL features, some additional functions,

Maximizing Efficiency with Teradata FastExport: A Powerful Tool for Exporting Large Volumes of Data between Teradata Vantage and Client Utilities

Teradata FastExport is a powerful tool for rapidly moving large volumes of data between Teradata Vantage and client utilities. This tool uses multiple sessions to export data to a mainframe-attached or network-attached file quickly. To execute Teradata FastExport, SQL statements in the FastExport script are executed. The tool has two

Understanding Teradata AMPs and their tasks in a Teradata system

What is a Teradata AMP?Teradata AMP (Access Module Processor) is a critical component in the Teradata system, responsible for managing and processing its data share. Each AMP operates as a Linux process, ensuring the even distribution of data rows across all AMPs using a hashing algorithm. Teradata systems, being

Teradata Roles: Simplifying Rights Management and Improving Performance

What are Teradata roles?Roles serve to simplify rights management. A user assigned a role automatically has the same rights as the role. What are the advantages of roles in Teradata compared to granting individual rights to users?The assignment of rights is simplified. An example: You define one role