Interested to Buy Any Domain ? << Click Here >> for more details...
Why Multiload does not supports USI and supports NUSI?
- 4 Answers
- 21425 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vinay
Index subtable row is on the same Amp as the datarow in
NUSI.so it operates each Amp independently and in parallel.
You can reach me on teradatavinay@yahoo.com
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / yuvaevergreen
Multiload handles every amp independently and parallely.
In case of USI, the index subtable would be present on
different amp which would necessiate the communication of
amps. But in case of NUSI, the imdex subtable would be
present in the same amp having the data row which allows
the mload to handles the amp independently. This is the
reason for supporting NUSI.
| Is This Answer Correct ? | 10 Yes | 2 No |
Answer / reddy
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. whenever we define a SI an SI subtable is
created in each AMP.For USI they go for a hash
distribution, and hence the actual data row pointed by the
USI subtable rows in one AMP may not be in the same AMP as
the subtable..so the AMPs
have to communicate, which is not supported by Multiload.
For NUSI the subtable will store references of only those
actual data rows who exist in the same AMP as the
subtable..they all point to the data in their own
AMP..hence AMPs dont need to communicate here.
Thus the AMPs work in parallal with NUSI and hence Mload
supports that.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / tdguy
USI involves multi amp communication whereas NUSI is amp
local. Due to this reason, Mload supports NUSI.
| Is This Answer Correct ? | 2 Yes | 0 No |
If RDBMS is halted what will you do ?
Which is more efficient group by or distinct to find duplicates?
What are the steps involved after the disk manager passes the request?
Difference between Qualify and group
what is single value and Multivalue ?
What can be achieved by using the teradata rdbms?
What are the various reporting tools in the market?
Different phases of multiload?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. yedu my email-id: jakkayedukondalu@gmail.com@gmail.com
How to run a query in teradata?
If the script is aborted. why it is aborted and how can you identify ?
How can you track login parameters of users in teradata?
Teradata 
