Why MultiLoad Utility supports only Non Unique Secondary
Index(NUSI) in the Target Table ?
Answer Posted / satya
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 ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
In Teradata, what is the significance of UPSERT command?
What is meant by a Least Cost Plan?
What is meant by a dispatcher?
What is the purpose of joins in teradata?
Highlight the advantages of PPI(Partition Primary Index).
What exactly do you know about catching in teradata?
What are the various indexes in teradata? How to use them? Why are they preferred?
What are the various indexes in teradata? How to use them?
What are the functions performed by bynet?
Where is teradata rdbms used?
Highlight the points of differences between the database and user in Teradata.
What is collect statistics?
What is the difference between global temporary tables and volatile temporary tables?
Why teradata is used?