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
- 39281 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
Which is more efficient group by or distinct to find duplicates?
Explain and compare pros and cons of snow flake schemas?
Highlight a few of the advantages that ETL tools have over Teradata.
How can you track login parameters of users in teradata?
What happens when a node suffers a downfall?
What is the syntax for case when statement?
How do you verify a complicated sql?
What is the function of parser component in teradata?
What is multi insert?
What are the different functions included in the server software?
How to Extract data from multiple legacy systems?
Explain the term 'row' related to relational database management system?
What are the various indexes in teradata? Why are they preferred?
Explain teradata architecture?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
