Interested to Buy Any Domain ? << Click Here >> for more details...
Why Multiload does not supports USI and supports NUSI?
- 4 Answers
- 21673 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is a dimension table?
What are default access rights in teradata? What explicit right can be given to a user?
Highlight the need for Performance Tuning.
What is smp and mpp platforms?
What do you mean by tpt in teradata?
What are some primary characteristics of teradata?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
Steps to create a data model?
What is the purpose of upsert command?
if collect stats but it show low confidence why?
What is the use of stored procedures in teradata?
How to eliminate product joins in a teradata sql query?
How do you do backup and recovery in teradata?
What are the different softwares used with their functions in teradata?
What is primary index and secondary index?
