What I Like About The Teradata Columnar Solution | DWHPRO
A Column Store is basically characterized by 3 properties:
Teradata Tutorial - Indexing | Index Selection Considerations | DWHPRO
The Teradata Tutorial to support the selection of indexes How much space does the Teradata index occupy? An index can take up surprisingly much space, especially if the Teradata system does not automatically apply Block Level Compression to the index. A NUSI can then take up many times the base table's space because multivalue compression is not applied to a NUSI! On what kind of table is the index needed? Depending on the type of table, different considerations are necessary regarding how…
Teradata WAL - The Write-Ahead Logic | DWHPRO
The bottleneck of database systems has always been accessing the data. As soon as the data is in the main memory, it can be processed.
What Snowflake Does Better Than Teradata: Zero-Copy Clones | Is It Possible? | DWHPRO
If a zero-copy clone of a table is created, the clone uses no storage because it shared the original table's existing micro-partitions when it was cloned. Only pointers are set for the cloned table, which points to the existing table's micro partitions.
Column Partitioning With The Primary AMP Index | DWHPRO
Anyone who has been dealing with Teradata for a long time knows what a primary index is. But at some point, a new term crept in with Teradata Release 15: Primary AMP Index.
Future And Past? Snowflake Versus Teradata | Can Snowflake Meet The High Expectations?
In this article, I will explain the main differences in the Architecture between Teradata and Snowflake.
8 Teradata Access Paths You Should Know | DWHPRO
The optimizer has various access paths to choose from when creating the execution plan. Each of these access paths has certain advantages and disadvantages. In this blog post I will introduce you to the 8 most important access paths. Do not be surprised that the hash index is not included. Teradata has completely replaced the hash index by the single-table join index and recommends in the latest documentation not to use it anymore. The single table join index can do everything the hash index…
How To Speed Up Your PPI Tables With A Secondary Index | DWHPRO
As we saw in the example where we queried a Teradata PPI table using only the Primary Index, it was necessary to check each partition to see if it contained the Primary Index value we were looking for.
Teradata DIAGNOSTIC HELPSTATS ON FOR SESSION | DWHPRO
Using the command "DIAGNOSTIC HELPSTATS ON FOR SESSION" we enable an option that displays the statistics required by the optimizer at the end of each execution plan (when the EXPLAIN command is used). Below is an example:
Teradata Identity Columns To Achieve Better Performance | Usage Considerations | DWHPRO
Teradata Identity Columns: You often need a counter that is automatically generated and is unique. Identity columns are ideal for this.
Teradata Identity Columns To Achieve Better Performance | Usage Considerations | DWHPRO
Teradata Identity Columns: You often need a counter that is automatically generated and is unique. Identity columns are ideal for this.