Interested to Buy Any Domain ? << Click Here >> for more details...
What is Join Index in TD and How it works?
- 6 Answers
- 36242 Views
- BT, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / tdguy
In this join index table, rows from two or more tables are
joined and stored in perm space. This table is updated
whenever the underlying rows are modified in the base
tables. These indexes can be very much useful for the
frequent queries. Advantage is faster processing.
Disadvantage is use of space and whenever join involves
atleast one column out of this join index, then this index
table would be of no use. Entire join would have to be done
separately.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How to view every column and the columns contained in indexes in teradata?
Highlight the need for Performance Tuning.
What is the purpose of indexes?
What are the joins in teradata and how many types of joins are there in teradata?
Why is the case expression used in teradata?
if collect stats but it show low confidence why?
How is MLOAD Client System restarted after execution?
What are the various etl tools in the market?
What are the functions of a Parser?
Can you connect multiload from ab initio?
Explain teradata vs. Redshift?
What are the available join types in teradata?
What are the primary characteristics of the Teradata.
Explain fallback in teradata?
Explain fastload in teradata?
