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
- 38944 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 teradata utilities. What is multiload, fast load, tpump?
Explain the term 'foreign key' related to relational database management system?
What is the opening step in basic teradata query script?
Explain PDE.
Why managing the data is important?
What is the purpose of joins in teradata and what are the available join types?
How do you set the session mode parameters in bteq?
What are the frequently used data types in teradata?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
Explain vproc in teradata?
What is the purpose of using case expression in teradata?
What is a sparse index?
Write a program to show the parser component used in teradata?
What exactly do you know about catching in teradata?
