Teradata
A collection of 307 issues
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
Why Teradata DBAs Should Prioritize Housekeeping the DBC AccessRights Table
As any experienced Teradata DBA will tell you, some tables in the Teradata dictionary (DBC) need housekeeping. But some customer sites that I have worked with ignore table DBC.AccessRights.
If you have ever analyzed this table on a Teradata system, you will almost certainly spot two things quickly.
1.
How to Improve Cardinality Estimations in Teradata: The Optimizer's Toolkit
Learn about Teradata Heuristics and Optimizer's approach to estimating cardinality for non-indexed columns in this article. Discover how skew improves estimations and why heuristics should be avoided.
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.