There is a lot of arguments brought forward for in-memory-databases. In principle, if we had unlimited memory, holding all data in memory would allow the fastest access. I think there is no doubt about this. As we all know, there always was and will be a huge difference in access times comparing memory against hard

Read More

Dealing with data skew can be considered a principal activity in Teradata performance optimization. Although skew on table level usually can be avoided by choosing a proper Primary Index, skew arising during query execution is often a major issue (so-called spool skew). Spool skew is often emerging when joining tables (or spools). On a typical Teradata

Read More