Performance Tuning
A collection of 267 issues
Why You Need a Performance Specialist for Your Data Warehouse Project
Optimizing Teradata Requests with Group-AMP Operations for Improved Performance
How to Find ASCII Code of a Character Using Teradata SQL
This course focuses on Teradata indexing techniques.
In this two-hour video, you will learn about Teradata's architecture and Full Table Scans, different types of Primary Index Access such as UPI and NUPI, diverse Secondary Index Access including USI and NUSI, and Join Indexes.
You will gain the comprehensive
Learn Teradata Indexing Techniques in this 2-Hour Video Course
Efficient Teradata Date Calculations Avoiding INTEGER Values
Learn how Teradata stores dates internally as INTEGER values and how to efficiently calculate dates after 1900-01-01 using a simple formula. Get more useful Teradata date calculations in this article.
Teradata DDL Best Practice: Use DELETE Instead of DROP for Efficiency and Resource Management
Learn why you should opt for DELETE instead of DROP when it comes to Teradata DDL. Avoid locking dictionary tables and conserve resources.
Is Teradata Compression Worth Your Time and Effort?
Teradata DBMS offers various compression options to save disk space and improve performance. But, the cost of implementing the compression takes man-time. This article discusses the cost vs. benefit of compression and suggests carefully considering the compression setting when designing new or modif
Benefits of Organizing Stored Procedures into Chapters and Steps
I made organizing Stored Procedures into Chapters and Steps a principle.
These separation points are marked by comments and variables used in performance and result logging.
A step refers to a technical or conceptual task that cannot be further divided without losing the abstraction of Stored Procedures or the main
Teradata Statistics: Understanding and Using Collected Metrics for Optimal Query Performance
Discover the importance of Teradata statistics in optimizing query execution plans. Learn how to collect statistics and when to use them for best results.