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

any one answer me how they can analyzing the project using data ware housing?

2257


Name the five phases that come under MultiLoad Utility.

797


How do you verify a complicated sql?

867


Is multi insert ansi standard?

1979


If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

1932


Explain parsing engine in teradata?

838


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2235


List out all forms of LOCKS that are available in Teradata.

771


How do you do backup and recovery in teradata?

828


My table got locked during mload due to a failed job. What do I do to perform other operations on it?

902


Explain teradata utilities. What is multiload, fast load, tpump?

804


Can we collect statistics on multiple columns?

799


Discuss the advantages of using partitioned primary index in a query?

765


What are the different methods ot loading a dimension table? A fact table etc?

834


How is MLOAD Client System restarted after execution?

863