Interested to Buy Any Domain ? << Click Here >> for more details...
Why MultiLoad Utility supports only Non Unique Secondary
Index(NUSI) in the Target Table ?
- 9 Answers
- 39259 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 happens when a node suffers a downfall?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
Explain the advantages of partitioned primary index in a query?
Explain the term 'primary key' related to relational database management system?
Explain the term 'database' related to relational database management system?
How is MLOAD Teradata Server restarted after execution?
What are the newly developed features of Teradata?
What are the steps to create a data model?
What do you mean by teradata sql assistant?
how do you manage the production space. what are the proactive methods you can take ?
What are the components provided on node?
What is multi insert?
What is the purpose of using case expression in teradata?
What is meant by a Clique?
What is oltp?
