Interested to Buy Any Domain ? << Click Here >> for more details...
What is Join Index in TD and How it works?
- 6 Answers
- 36500 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
Discuss the advantages of using partitioned primary index in a query?
What are the main components of teradata system?
What is the function of parser component in teradata?
Why do you get spool space errors? How do trouble-shoot them?
Describe the set operators in teradata.
What do you mean by fastexport in teradata?
What are the available primary index types in teradata.
Write a program to show the parser component used in teradata?
What is a node in teradata?
What is the difference between fastload and multiload? Which one is faster?
How do you verify a complicated sql?
What is the use of having index on table?
Explain the types of join supports by teradata?
What are the things to be considered while creating secondary index?
How is the teradata different from oracle?
