Teradata SQL Performance: IN vs BETWEEN and the Use of Statistics on Columns
Learn about optimizing SQL queries in Teradata 14.10 by analyzing the execution plan of two queries and using statistics on columns and expressions.
SQL Tuning
Improve Query Performance by Using the Teradata CLOB Datatype for Storing Longer Texts
Learn how the Teradata CLOB datatype can improve query performance and reduce resource consumption for storing longer texts in your database.
Teradata Join Optimization: Early and Partial GROUP BY Techniques for Decision Support Workload
Learn how Teradata applies two effective join optimization methods, Early and Partial GROUP BY, for decision support workloads with lots of aggregations. These transformations reduce resource usage and are widely used in modern databases. Discover how to improve the optimizer’s chance to apply these techniques by collecting statistics on all join and aggregation columns.
Static and Dynamic SQL Characteristics: Examples and Differences
Learn about the characteristics of static and dynamic SQL in Teradata stored procedures. Discover how to use variables and parameters in SQL statements.
How to Avoid Full Table Scans When Using LIKE Operators in Teradata Indexing
Learn how to avoid resource-killing full table scans on extensive tables with Teradata Indexing. Discover a fantastic trick to optimize query performance.
Teradata SQL Stored Procedures: Adding Procedural Functionality to Your RDBMS
Teradata SQL Stored Procedures enhance traditional SQL with procedural language features like iterations, condition and error handling, and variables. Learn more here.
Improve Performance with Teradata Partition Elimination: The Stored Procedure Approach
Learn how to solve the problem of accessing a table containing many rows using Teradata Partition Elimination with a Stored Procedure.
A Guide to Teradata SQL: Features, Optimization, and Queries
Discover the power and unique features of Teradata SQL, the dialect of SQL used within Teradata’s large-scale data warehousing and analytics platform. Learn about its differences from standard SQL and how to run queries using Teradata SQL Assistant and BTEQ.
Teradata OLAP Functions: A Systematic Approach to Understanding Window Aggregates
Learn how to work with Teradata OLAP Functions in your data warehouse applications. This systematic approach covers five key design decisions.
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.