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
- 38878 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 type of indexing mechanism do we need to use for a typical data warehouse?
How to identify ppi columns?
How does hashing happens in teradata?
Explain the teradata primary index mechanics in detail with a diagram.
What is collect statistics?
What is the use of virtual processor connectivity in teradata?
Why is the case expression used in teradata?
Explain vproc in teradata?
How can you track login parameters of users in teradata?
In BTEQ, how are the session-mode parameters being set?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What are the design features involved in teradata?
What are the 5 phases in a multiload utility?
What are the different softwares used with their functions in teradata?
What is the purpose of using case expression in teradata?
