Interested to Buy Any Domain ? << Click Here >> for more details...
What is Join Index in TD and How it works?
- 6 Answers
- 35950 Views
- BT, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / rashid equbal
Join Index is nothing but pre-joning 2 or more tables or
views which are commonly joined in order to reduce the
joining overhead.
So teradata usdes the join index instead of resolving the
joins in the participating base tables.
They increase the efficiency and performance of join
queries.
They can have different primary indexes than the base tables
and also are automatically updated as and when the base rows
are updated. they can have repeating values.
There are 3 types of join indexes:
1) Single table join index - here the rows are distributed
based on the foreign key hash value of the base table.
2) Multi table join index - joining two tables.
3) Aggregate join index - performing the aggregates but
only sum and count.
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
Explain the types of join supports by teradata?
List the logical and conditional operators that are used with teradata along with their meanings?
Explain the term 'columns' related to relational database management system?
What is the basic syntax for teradata select statement?
During the Display time, how is the sequence generated by Teradata?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What are the various indexes in teradata?
What are aggregate tables? How do you design them using teradata?
What is the use of fallback?
What is the difference between fastload and multiload? Which one is faster?
Highlight the advantages of PPI(Partition Primary Index).
What is the primary index in teradata?
Difference between multiload and tpump?
