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 joins in teradata?

575


How do you define Teradata?

613


what are the day to day activities of teradata DBA ?

5378


What is meant by a Clique?

593


What is inner join and outer join?

622






Did you write stored procedures in teradata?

623


Highlight the need for Performance Tuning.

595


What is teradata?

652


What is the maximum number of dml can be coded in a multiload script?

625


What interface is used to connect to windows based applications?

588


What is the difference between fastload and multiload? Which one is faster?

603


Explain the term 'primary key' related to relational database management system?

607


Difference between star and snowflake schemas?

609


What is the purpose of joins in teradata?

548


How to view every column and the columns contained in indexes in teradata?

591