Interested to Buy Any Domain ? << Click Here >> for more details...
What is Join Index in TD and How it works?
- 6 Answers
- 36248 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
Explain the term 'tables' related to relational database management system?
How do you create tables? Exact syntax, and create profiles, users in teradata?
How do you determine the number of sessions?
What is bteq utility in teradata?
What are the available join types in teradata?
Highlight the advantages of PPI(Partition Primary Index).
What do high confidence, low confidence and no confidence mean in explain plan?
What are the different table types supported by teradata?
What is the difference between teradata and oracle?
Explain BYNET.
How to identify ppi columns?
How will you solve the problem that occurs during update?
What are the 5 phases in a multiload utility?
What is the difference between fastload and multiload? Which one is faster?
any one answer me how they can analyzing the project using data ware housing?
