Interested to Buy Any Domain ? << Click Here >> for more details...
What is Join Index in TD and How it works?
- 6 Answers
- 36055 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
What happens in a conflict? How do you handle that?
What are the various indexes in teradata?
What is dimensional modeling?
How many codd's rules are satisfied by teradata database?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
How is the teradata different from oracle?
Explain some differences between mpp and smp?
What is basic teradata query language?
What are the updated features of teradata?
What are some commonly used bteq scripts?
What are tpump utility limitations?
What is logical data model?
any one answer me how they can analyzing the project using data ware housing?
What are the uses of client software involved in teradata?
Explain the advantages of partitioned primary index in a query?
