What is Join Index in TD and How it works?
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 syntax for case when statement?
Can you fastexport a field, which is primary key by putting equality on that key?
What is primary index and secondary index?
How you will check the version of teradata?
What is meant by a Highest Cost Plan?
How many sessions of MAX is PE capable of handling at a particular time?
If a Node is busy what are the steps you can take to avoid ?
Explain the term 'tables' related to relational database management system?
How do you verify a complicated sql?
How do you do backup and recovery in teradata?
How can bottlenecks be identified?
What is the purpose of joins in teradata and what are the available join types?
What are the primary characteristics of the Teradata.
How is MLOAD Teradata Server restarted after execution?
What is the use of teradata system software?