Teradata Explain EXPLAIN command is the Parsing Engines (PE’s) plan to the AMPs. EXPLAIN command returns the execution plan of the parsing…
Tag:
teradata tables
-
-
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 Join Index The Teradata Join index stores pre-joined tables. Join indexes are comparable to materialized views. Join indexes are designed to…