Interested to Buy Any Domain ? << Click Here >> for more details...
What is Join Index in TD and How it works?
- 6 Answers
- 36278 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
What are default access rights in teradata?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What are the main components of teradata system?
What is collect statistics?
Explain the teradata primary index mechanics in detail with a diagram.
Explain the meaning of Amp?
How is MLOAD Client System restarted after execution?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
Explain the most common data types used in teradata?
Different phases of multiload?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What is the use of virtual processor connectivity in teradata?
What is smp and mpp platforms?
What is the maximum number of dml can be coded in a multiload script?
