Character Conversion Archives

Get the DWHPro Book

Reach us on social media

Data Modeling and the Teradata FSLDM

Optimal Performance Through The Correct Use Of The Teradata Partitioned Primary Index

Teradata Compression with the DWHPRO TITHONIZER

Advantages and Disadvantages of Teradata SET and MULTISET Tables

Teradata Tuning Success – The Best Ever

As a Teradata SQL tuner, most of the time, we have to deal with skew. In my experience, up to 90% of SQL performance issues are related to skew. But this article is not about skew. Sometimes a slight change is enough to produce miracles. In this article, I show the possible impact of wrongly

SQL Tuning

The Teradata CHAR2HEXINT Function

A recent blog of Roland Wenzlofsky introduced us to the CHAR2HEXINT function to extract coding table numbers for tokens. If you found this a little off the scope of practical problems you have to deal with on a daily basis, let me tell you that exactly these functions just helped us a lot in solving