Teradata Tutorial

Teradata Secondary Indexes Secondary indexes are never required for Teradata Database tables, but they can often improve system performance. A Secondary Index…

Teradata FastExport Teradata FastExport is a command-driven utility used to transfer large amounts of data from tables and views of the Teradata…

Teradata Select Statement The SELECT statement is the most frequently used SQL statement. The SELECT statement is used to retrieve records from…

Teradata FastLoad Teradata FastLoad is used to load a large amount of data in an empty table on a Teradata System or…

Teradata Set Operator SET operators combine results from multiple SELECT statements. This may look similar to Joins, but joins combines columns from…

Teradata Hashing Algorithm The hashing algorithm is a piece of code that acts as a translation table. A row is assigned to…

Teradata Space Concepts Teradata is designed to reduce the DBA’s administrative functions when it comes to space management. Space concepts are configured…

Teradata Statistics Teradata optimizer gives an execution strategy for every SQL query. This execution strategy is based on the statistics collected on…

Teradata Aggregate Functions Aggregate functions are typically used in arithmetic expressions. Aggregate functions operate on a group of rows and return a…

Teradata Architecture The architecture of Teradata is a Massively Parallel processing architecture. The Teradata system has four components. Parsing Engine BYNET AMPs…