What is Join Index in TD and How it works?
Answer Posted / kiran
It is an indexing structure containing columns from one or
more base tables.
supose one query frequently request a perticular join on
multiple tables that is recomdable.
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are the various etl tools in the market?
What are the string manipulation operators and functions associated with teradata?
What are the different functions performed in development phase?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What is the purpose of using case expression in teradata?
What are some primary characteristics of teradata?
Explain the most common data types used in teradata?
Explain amp in teradata?
Can you connect multiload from ab initio?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What are the different table types supported by teradata?
Explain the parallel data extension in teradata?
What are the uses of bynets in multi-node systems?
What is the use of fallback?
What is meant by a Least Cost Plan?