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


Please Help Members By Posting Answers For Below Questions

What are the various etl tools in the market?

841


What are the string manipulation operators and functions associated with teradata?

852


What are the different functions performed in development phase?

836


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?

960


What is the purpose of using case expression in teradata?

780


What are some primary characteristics of teradata?

755


Explain the most common data types used in teradata?

787


Explain amp in teradata?

761


Can you connect multiload from ab initio?

918


Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

810


What are the different table types supported by teradata?

747


Explain the parallel data extension in teradata?

850


What are the uses of bynets in multi-node systems?

796


What is the use of fallback?

769


What is meant by a Least Cost Plan?

812