What is Join Index in TD and How it works?

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


Please Help Members By Posting Answers For Below Questions

What is real time and near real time data warehousing?

893


What are the 5 phases in a multiload utility?

817


Write a program to show the parser component used in teradata?

752


What are the newly developed features of Teradata?

795


Describe the set operators in teradata.

781


Explain teradata architecture?

858


If RDBMS is halted what will you do ?

1918


What is oltp?

765


How would you load a very large file in teradata in general? What utility would you use for it? Why?

870


What is upsert statement in teradata?

834


What is the difference between fastload and multiload?

1036


what is sysdba and sysdbc ? which has high priority ?

3590


How is MLOAD Client System restarted after execution?

845


What happens in a conflict? How do you handle that?

847


why use references rather than pointers in the public api, particularly for arguments which are modified?

776