Interested to Buy Any Domain ? << Click Here >> for more details...
What is Join Index in TD and How it works?
- 6 Answers
- 36489 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 the commands to make a new table, change a table and remove a table in teradata?
How to identify ppi columns?
How does hashing happens in teradata?
What are the uses of bynets in multi-node systems?
What are the different design perspectives used in teradata?
What type of indexing mechanism do we need to use for a typical data warehouse?
Can we collect statistics on table level?
why use references rather than pointers in the public api, particularly for arguments which are modified?
Explain some differences between mpp and smp?
Explain Teradata performance tuning and optimization?
List out some of the primary characteristics of teradata.
Explain teradata utilities?
How would you load a very large file in teradata in general?
What happens when a node suffers a downfall?
Discuss the advantages of using partitioned primary index in a query?
