What is Join Index in TD and How it works?
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 are the various indexes in teradata? How to use them? Why are they preferred?
Differentiate primary key and partition key?
What is the function of parser component in teradata?
What is meant by a Virtual Disk?
What do high confidence, low confidence and no confidence mean in explain plan?
How many codd's rules are satisfied by teradata database?
What is the purpose of joins in teradata and what are the available join types?
What are types of partition primary index (ppi) in teradata?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
How to view every column and the columns contained in indexes in teradata?
How to run a query in teradata?
What are normalization, first normal form, second normal form and third normal form?
What are the things to be considered while creating secondary index?
How you will check the version of teradata?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you