Teradata
A collection of 307 issues
How to Find ASCII Code of a Character Using Teradata SQL
Learn Teradata Indexing Techniques in this 2-Hour Video Course
Introduction
Teradata SQL lacks a built-in function to determine the ASCII code of a character. But fear not, for there exists a query workaround to this dilemma. This blog post will guide you through the process of using a straightforward SQL query in Teradata to find the ASCII code of
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
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.