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.
Learn the differences between Teradata SUBSTR and SUBSTRING functions for string manipulation. Discover the syntax variations, parameters, and usage examples.
Learn how to clone tables in Teradata quickly and easily using the CREATE TABLE AS statement. Transfer statistics and definitions without wasting resources.
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 correspond to specific components of …
Learn how to handle errors in Teradata Stored Procedures. Error handlers provide event-driven functionality and make error handling more efficient.
Learn how Teradata macros can improve your database efficiency with reusable blocks of SQL code. Create macros once, execute them anytime!
Introduction to Teradata Temporary Tables This article highlights the distinct types and uses of Teradata temporary tables. 1. Derived Tables To avoid syntax errors, tables derived from queries should always be given an alias. Here is a derived table example (in parentheses): SELECT * FROM (SELECT MAX(Revenue) FROM Invoices) AS InvoiceRevenue (MaxRevenue); The table is …
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.
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.
The Teradata TO_CHAR Function Utilize the Teradata TO_CHAR function to: This is an example of a numeric expression argument, which can be any of the following data types: BYTEINT, SMALLINT, INTEGER, BIGINT, DECIMAL/NUMERIC, FLOAT/REAL/DOUBLE PRECISION, or NUMBER. The format string, which must be of type CHAR or VARCHAR, represents the second argument (Further information on …
Expert network for enterprise data platforms. Senior consultants, project teams built for your challenge — across Teradata, Snowflake, Databricks, and more.
📍Vienna, Austria & Jacksonville, Florida
Join 4,000+ data professionals.
Weekly insights on Teradata, Snowflake & data architecture.