teradata substring

Teradata Installation Teradata provides Teradata express for VMWARE, which is a fully operational Teradata virtual machine. It provides up to 1 terabyte…

Teradata Performance Tuning In Teradata, Performance tuning is done to identify all the bottlenecks and then resolve them. The bottleneck is not…

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…