Interested to Buy Any Domain ? << Click Here >> for more details...
Why Multiload does not supports USI and supports NUSI?
- 4 Answers
- 21672 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 do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What is the function of parser component in teradata?
What are the functions involved in shared information architecture?
Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance
in ur table contains the coloumns like deptno,sal empname then i want output as deptno subtotalofdept totalsal 10 3700 3700 20 3400 7100 like that
How to run the Teradata jobs in unix environment ???
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. Rajesh my email-id: rajeshmss87@gmail.com
Difference between client character set and server character set? What is the use of these two?default character set in teradata?
Describe primary index in teradata. And what are the available primary index types?
What are the enhanced features in teradata v2r5 and v2r6?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
Can any one plz provide the teradata interview questions?
Teradata 
