Why MultiLoad Utility supports only Non Unique Secondary
Index(NUSI) in the Target Table ?
- 9 Answers
- 36161 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rajesh kumar s
MulitLoad has support for Non-Unique Secondary Indexes
(NUSIs) since NUSIs are AMP Local. They have subtable within
base table. It has no hash bucket to redirect to another
amp, everything points to their own amp (AMP Local)
If you go with USI, it has hash bucket, which might redirect
to another amp, more possibilites for full table scan.
Motive for avoiding Indexes(other thn NUSI): Avoid Full
table scan.
Regards
Rajesh Kumar S
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is the difference between global temporary tables and volatile temporary tables?
What's the difference between timestamp (0) and timestamp (6)?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
During the Display time, how is the sequence generated by Teradata?
How to identify ppi columns?
What are the available primary index types?
What do you mean by tpt in teradata?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What is the command in bteq to check for session settings ?
What is real time and near real time data warehousing?
How many sessions of MAX is PE capable of handling at a particular time?
What are types of partition primary index (ppi) in teradata?
Highlight the limitations of TPUMP Utility.
why use references rather than pointers in the public api, particularly for arguments which are modified?
Explain the term 'primary key' related to relational database management system?
