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
What is the use of teradata system software?
What is oltp?
Explain vproc in teradata?
What do you mean by ttu in teradata?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
How will you solve the problem that occurs during update?
Explain teradata vs. Redshift?
What is the command in bteq to check for session settings ?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What are teradata utilities?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What is the multi-insert?
What is basic teradata query language?
What are the updated features of teradata?
What is the purpose of joins in teradata and what are the available join types?