Introduction to Teradata Data Types Further Data Type considerations require occasional attention to additional issues. Happenstance Nullability Strive for nullability ...

Teradata Data Type Considerations

Teradata Table Design Checklist As creating tables is a frequent task, I deemed it necessary to provide a checklist. Primary ...

Teradata Table Design Checklist: Primary Index, Character Set, and Data Type Considerations

As a Teradata SQL specialist, skew is a common challenge. In fact, approximately 90% of SQL performance difficulties stem from ...

The Impact of Character Sets on Teradata SQL Performance: A Case Study

What are Decomposable Columns? Decomposable columns are those that can be divided. They indicate a lack of normalization in the ...

Decomposable Columns: Definition, Impact on Performance, and Workarounds

The importance of the PDM Compression is a widely used method for reducing IOs by enabling the accommodation of more ...

The Importance of PDM in Database Compression and Resource Usage Optimization

Longer texts, such as descriptions of other columns, are stored in VARCHAR() columns. The maximum character capacity for storage is ...

Improve Query Performance by Using the Teradata CLOB Datatype for Storing Longer Texts