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
- 38625 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
Explain parsing engine in teradata?
How do you define Teradata?
Explain Teradata performance tuning and optimization?
What is a node in teradata? Explain
What happens when a node suffers a downfall?
What is a node in teradata?
What is collect statistics?
Highlight the limitations of TPUMP Utility.
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
Why is the case expression used in teradata?
What are default access rights in teradata?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
How to view every column and the columns contained in indexes in teradata?
Describe the set operators in teradata.
How would you load a very large file in teradata in general?
