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

Read More

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

Read More