Interested to Buy Any Domain ? << Click Here >> for more details...
What is Join Index in TD and How it works?
- 6 Answers
- 36272 Views
- BT, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / veni botcha
JOIN INDEX:
-----------
Join Index is nothing but pre-joining 2 or more tables or
views which are commonly joined in order to reduce the
joining overhead.
So teradata uses 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 ? | 43 Yes | 9 No |
Post New Answer View All Answers
What is the difference between union and union all in teradata?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What is inner join and outer join?
Explain the term 'row' related to relational database management system?
What is the difference between fastload and multiload?
In the Primary Index, what is the score of AMPs that are actively involved?
How to identify ppi columns?
Syntax for case when statement?
How can you track login parameters of users in teradata?
List out teradata data types?
What are the uses of bynets in multi-node systems?
How can we check the version of Teradata that we are using currently?
What is the purpose of indexes?
What is real time and near real time data warehousing?
