Interested to Buy Any Domain ? << Click Here >> for more details...
Why Multiload does not supports USI and supports NUSI?
- 4 Answers
- 21465 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 |
How to find duplicates in a table?
How do you determine the number of sessions?
Explain and compare pros and cons of snow flake schemas?
How can you track login parameters of users in teradata?
How can we load single row of data into teradata database. please give me the process.
1.what is activity count? 2.what is skew factor? how it's working explain brefily
During the Display time, how is the sequence generated by Teradata?
What are the various indexes in teradata? How to use them?
how teradata fetches a row from primary index table?
What are teradata utilities?
What do high confidence, low confidence and no confidence mean in explain plan?
What is the basic syntax for teradata select statement?
Teradata 
