Interested to Buy Any Domain ? << Click Here >> for more details...
What is Join Index in TD and How it works?
- 6 Answers
- 36502 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 multi insert?
What are the various indexes in teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
Is multi insert ansi standard?
What are the various reporting tools in the market?
Can you fastexport a field, which is primary key by putting equality on that key?
What are the commands to make a new table, change a table and remove a table in teradata?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What do you mean by teradata intellicloud?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
How to find duplicates in a table?
What are the newly developed features of Teradata?
What is meant by Teradata Gateway?
What do you mean by tpt in teradata?
Explain teradata utilities. What is multiload, fast load, tpump?
