Interested to Buy Any Domain ? << Click Here >> for more details...
Why MultiLoad Utility supports only Non Unique Secondary
Index(NUSI) in the Target Table ?
- 9 Answers
- 38877 Views
- IBM, I also Faced
- E-Mail Answers
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 are the frequently used data types in teradata?
What is meant by a Highest Cost Plan?
What are the different table types that are supported by teradata?
What are the steps involved in the process flow of the sql statement through channel attached system?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
In general, how do you optimze any sql in teradata?
What are types of partition primary index (ppi) in teradata?
What is the multi-insert?
Highlight a few of the important components of Teradata?
How can bottlenecks be identified?
Describe primary index in teradata. And what are the available primary index types?
Explain the types of join supports by teradata?
What are the enhanced features in teradata v2r5 and v2r6?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
Explain the advantages of partitioned primary index in a query?
