what is teradata

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 Join Index The Teradata Join index stores pre-joined tables. Join indexes are comparable to materialized views. Join indexes are designed to…

Teradata Stored Procedure A stored procedure contains a set of SQL statements and procedural statements. They consist of a set of control…

Teradata Join Strategies Teradata Join Strategies are utilized by the optimizer to choose the minimum cost plan and better performance. The strategy…