Sign in Subscribe

Utilities & Loading

A collection of 89 issues

Optimizing Teradata System Performance: Identify and Improve Resource-Consuming Queries

Improve the Performance of your Teradata System Executing the following query may reveal that a small number of queries are responsible for consuming a significant portion of the resources in the Teradata System. Improving the performance of these queries can greatly impact the system's overall health. Your Teradata

Teradata Multivalue Compression and Presence Bytes for NULL Values

Multivalue compression and null indication serve distinct purposes yet share a common objective of storing information about the values of each row's columns. To conserve space, Teradata utilizes presence bytes to retain information on multivalue compression and nullability. Readers familiar with earlier releases will recognize that the name

Why You Need a Performance Specialist for Your Data Warehouse Project

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.

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.

Benefits of Organizing Stored Procedures into Chapters and Steps

Teradata Locking Logger: How to Enable and Analyze Lock Activity

Introduction to Teradata Big Data Blocks: Advantages and Disadvantages

Teradata Utility Workload Management: Overview and Protocols

Learn about Teradata Utility Workload and its specialized and optimized user requests that are not SQL protocol-based. Explore its protocols and management techniques.

Understanding Teradata Workload: Definition, Advantages, and Characteristics

Learn about Teradata Workload and its benefits in this article. Workloads group requests with common characteristics, making it easier to manage them.